Query for simple time series

Grafana
1

Hi everyone,

I have a very simple MySQL table that records the number of tickets we have at each priority.

db

I have tried to follow

Unfortunately, Grafana returns errors when I try and adapt the examples. What query do I need in order to return a graph that shows the number of tickets we have?

Thanks

James

2

Show us the query you have tried and what the error is.

3 
SELECT
  $__timeGroup(poll_time,'5m') as time,
  highest as metric
FROM icd133
WHERE $__timeFilter(poll_time)
GROUP BY time
ORDER BY time;

Returns “Query failed”

4

Found it! PEBKAC - I was using the wrong data source. Sorry!