I am using an utility meter connected to a sensor with Efergy. I am able to estimate consumption by time period, estimate EOM bill and many other things by using simple templates.
It all works good, BUT (there is always a but), now I want to add one more thing (wife request). I want to compare cumulative consumption of a period (i.e., today until 3.30pm) with the same time expand the period before (i.e. yesterday until 3.30pm). The idea is to be able to see whether I am or not aligned with intraday consumption. Does this even make sense? How would you go about it?
My last resource would be to create a Py script running vs. HASS DB and publishing the data into MQTT, but I am pretty sure there should be something more simple