Grouping data from a time series into slices

  • What Grafana version and what operating system are you using?
    most recent

  • What are you trying to achieve?
    I have a constant growing time series from my power counter and like to view the numers in daily or monthly or yearly bars.

  • How are you trying to achieve it?
    SELECT
    $__unixEpochGroup(ts/1000,‘1d’) as “time”,
    max(val) as “Starts”
    FROM iobroker.ts_number
    where id = 5570 and val>0
    group by time
    order by time desc

  • What happened?
    only growing bars.

  • What did you expect to happen?
    bars per day (,month,year)

  • Can you copy/paste the configuration(s) that you are having problems with?
    see above

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    no

  • Did you follow any online instructions? If so, what is the URL?
    no