Daily consumption in kWh 1 bar per day


I am getting daily consumption from floor heating in kWh. It comes from HA-influx DB.
So the value is resetting to 0 every midnight. I would like to have a bar chart which is showing one bar per day. The bar should be rising during day. I tried to play with bar chart and but could not achieve this goal. Please can anybody advise?

Can you change the GROUP BY to 24h or 1d?


Yes I already tried this but for some reason it doesn’t show accurate value. The value is smaller

do you want to show average?

I had the same issue for my daily energy count of my solar panels. I used a flux statement with the aggregateWindow function to solve this issue:
This is my raw data:

And this the final result in Grafana:

This is one of the 2 queries I’m using:

from(bucket: "iobroker")
  |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => (r._measurement == "pv_gartenhaus_energy_daily") and r._field == "value")
  |> aggregateWindow(every: 1d, fn: max, timeSrc: "_start")
  |> set(key: "_field", value: "Gartenhaus")