Hello, I have the value of my Electricity counter (kWh) in a series. Now, I’d like to show in a pie-chart the power consumed over $__interval. With a fixed time of -say- a day, this query works: SELECT max(“value”)-min(“value”) FROM “eg.Wohnzimmer.Hauptlicht.Verbrauch” WHERE $timeFilter GROUP …

Difference of min and max over $__interval

patvdleer June 12, 2021, 4:07pm 7

Anyone any luck with getting a spread based on the interval?

1 Like