Daily consumption in kWh 1 bar per day

Hi,

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?

image

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")