I will prefix this with I am a total noob. I have my weather station pumping data into the database and I am wanting to track rainfall for a period (i.e last 7 days or last 30 days). The rain data comes in as a aggregate of the day i.e:
14-08-2019 15:30 20.00
14-08-2019 16:00 20.10
14-08-2019 16:30 20.10
I know i need to get the max value of each day, then for a period of 7 days or 30 days (or however long i want to track) I need to add those days together. I have seen this post - Sum the max value of every day in grafana and Singlestat sum of max values for different tags in a measurement. However I am too much of noob to fully understand how to implement the solutions in this instance. I am hoping someone could help me out to achieve what I want.