I am collecting data from an energy sensor on a daily basis. This energy sensor, however, does not return one value per day but rather continuously adds wnergy consumption and then resets at midnight.
What I would like to do is see just the final maximum value of the calendar day.
My current configuration is
SELECT last(“value”) FROM “Wh” WHERE (“entity_id” = ‘daily_energy_boiler_1’) AND $timeFilter GROUP BY time($__interval) fill(none)
which gives me
The top one is the live consumption in watts and the bottom one the one I want to change (in watt hours).
Would someone help me please? I am sure Grafana with InfluxDB is easily capable of doing this, but I cannot figure it out