Hi! Going a bit crazy here trying to get some kind of group by $__interval_ms going for my mysql timeseries query.
How do I add a group by here, using the $__interval_ms to get the proper grouping for the resolution in the graph?
SELECT shortTime as time,
cpu as value,
‘RKBOX CPU’ as metric
ORDER by time ASC