Hi
I have a pulse meter that feeds data into utility sensors for daily, weekly and monthly sensors.
I want to get a value for an average daily water consumption in a current month, like I get from the utility company reports.
This is what I get from the daily consumption sensor - resets at midnight. So I want the average of the max(last reading) daily values in a current month
Tried various ways but have no idea how to go about it
I dont really need the complexity of working out how many days in a current month etc, so maybe just a rolling average of the max values for each day of the last 30 days