Need help to get a daily average for water consumption

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

Hello, same here ! Did you find any solution ?

there seems to be no easy to calculate the daily or weekly average and create it as a sensor. All the answers are either smart ass answers or SQL or complicated Templates. This is where HA falls over on simple things like this i reckon.

1 Like

I am doing a weekly/monthly utility meter and just doing average sensor based on utility sensor divided by the current day of the month/week