Folks,
I’m struggling with rolling day averages. I log the runtimes of various pieces of equipment and would like to create a 7 day rolling average.
To pick an easy example, to create a 7 day rolling average of household power consumption. I have a Solis inverter with a sensor that measures daily household consumption. This resets at midnight. I have created a helper and automation. The helper is an input button. (Yesterday’s power consumption). The automation logs this value at 23.55 to the helper. It appears the statistics helper cannot use the input number as a source.
From playing around with things it seems I have to create some sort of snapshot to use as the source for the rolling average. Using utility meters does not work as the statistics helper will take the average of the day rather than the max value.
Any advice, I’m sure it can be done, I’m just struggling with it at them moment.