I have the followin goal: I would like to see for rain
- daily max value and
- its cummulative sum in the selected interval
Both of which I figured out how to query the database and display it nicely in a graph.
Problem: The sensor I use zeros every mornig at 0700 (Homematic IP Weather Sensor Plus). Situation: It rains 10mm on day x and stops at 2200. Max value on day x is 10mm. Then on day y it does not rain at all. But since the sensor zeros on 0700 on day y I get max value 10mm (from day x) for day y (instead of 0mm).
Changing the programming of the device is not possible with my setup. So is there possibility to calculate the correct amount of rain with a grafana query?
I use InfluxDB.