Statistics Diagram with water usage as 1 bar per day

1

Hi all

I have a sensor which provides me the absolute water gauge value (https://github.com/jomjol/AI-on-the-edge-device).

I am using an Utility Meter helper (Utility Meter - Home Assistant) to reset the counter every day. This seems to work as expected:

Screenshot_20220831_111531
Screenshot_20220831_1115311656×524 26.9 KB

Now I would like to show the daily usage with a bar per day. I tried to use a Statistics Diagram for this, how ever for an unknown reason it only shows a sum (which additionally seems to be wrong):

grafik
grafik979×764 32.8 KB

How do I have to do it to get the relative usage per day as a bar per day?

I am also feeding my data to an InfluxDB and successfully got this working there (as a comparison):

grafik
grafik579×797 32 KB

Query: SELECT (max("value") - min("value"))*1000 AS "mean_value" FROM "homeassistant"."autogen"."sensor.wasserzaehler" WHERE time > :dashboardTime: AND time < :upperDashboardTime: GROUP BY time(1d) FILL(null)