Is there a way to have the graph start at zero at the start of each day?
In a energy consumption graph I limit the view to a single day, I would also like the values to be that of that day only.
I use: SELECT mean(“value”) FROM “emeter_delivery” WHERE timeFilter GROUP BY time(__interval) fill(previous)
So instead of the first value being 16006 and increasing during the day, I’d like to have the first value 0 and then increase during the day.
Effectively substracting the value at 00:00 from all other values.
Does anyone know how to do this??