Daily consumption in kWh 1 bar per day

Grafana Dashboards
1

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?

1
11468×754 57.1 KB

2

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

image

3

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

1
11661×879 65.9 KB

4

do you want to show average?

5

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:

image
image1989×320 23.3 KB

And this the final result in Grafana:
image
image2341×552 30.8 KB

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