i’m trying to build a graph panel to monitor the ammount of support tickets per day.
Data source is a postgresql database. Within the table there are the follwoing columns:
- “created” - timestamp without timezone //ticket creation time
- “ID” - integer //ticket id
- some other, not relevant columns
Datasource is set up and working; it´s used in other panels succesfully.
My query is build like this:
select EXTRACT(EPOCH from "created") as time ,count("ID") as value ,'Count' as metric from tickets group by "created"
Metrics are formatted as timeseries, all other options are default.
Grafana shows the message “data points outside time range” and nothing is shown as graph. If I switch X-Axis to mode “Series” there is one single bar shown as graph, if I switch to mode “histogram” there are shown 3 bars: on at x-coord1.0 with count = 3538, one at x-coord 2.0 with count 159 and one at 3.0 with count 7
In any Query-Tool or in a Table-Panel in Grafana my query shows that there are between 55 and 202 tickets by day.
Can anyone leave a hint, what´s wrong in my config or query?