Postgresql No data points

Grafana Time Series Panel
1

Hello,

I start my second day with grafana. I have a problem. I put as data source a database PostgreSQL I tested the connection it works very well. My table looks like that.

ttttst
ttttst1291×225 13.5 KB

My request is:
select id,count(id) from warranty group by delivery_date,id

Axes :

axes
axes998×409 21.5 KB

I have no information. I searched on the internet I do not really understand what to do. Videos on youtube do not show how they are source tables and how to create metrics with queries. Someone can point me on the right track please. Thank you

2

For Grafana to make sense of your data the resultset your query returns has to be structured a certain way unless you are doing a table query. Your resultset must have a column named time that represents the timestamp.

Check Time Series Queries under http://docs.grafana.org/features/datasources/postgres/