Hi, 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) fi…

Manually substracting the value read at 00:00 in the query gives the desired result: SELECT mean(“value”) - 16382 FROM “emeter_delivery” WHERE $timeFilter GROUP BY time($__interval) fill(previous) [engraph2] How can I query the value at 00:00 from the db and use it.

Rewrote part of query so that grouping is now working as well. B in yellow is the original query, A (green) the modified one. The scales might be off a bit, but looking at the shape of the graph it looks fine like this. SELECT CUMULATIVE_SUM(difference) FROM (SELECT DIFFERENCE(mean) FROM (SELECT M…

Create daily graph starting at zero (0)

Grafana InfluxDB

coyote January 15, 2018, 10:47am 3

The following seems to work. Adding GROUP BY invalidates the query

Topic		Replies	Views
How to plot the data difference from the start of chart time InfluxDB	1	509	November 23, 2021
Display Graph Relative to Zero Grafana	1	596	February 8, 2019
Get daily usage from cumulative energy values, only 1 value/day, but not always added at same time InfluxDB	1	1711	February 7, 2022
Daily consumption for one day is showing one day after InfluxDB	6	1057	January 1, 2024
Extending daily reseting values to midnight InfluxDB	3	229	June 19, 2024

Create daily graph starting at zero (0)

Related topics