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