Hi there, i am running a couple of solar panels with an 800w inverter. Power output is measured with a tapo wifi plug and tracked in homeassistant. So far this works great. I’ve managed to create a graph which displays the daily sum of generated solar energy. The tapo integration provides a daily and monthly energy sum.
I now would like to add an overall generated solar energy sum and display it in a dashboard. Is there a way do to an all time sum of all the gathered energy data?
A SQL sensor will probably be best.
…Or use an input_number in which you add the daily production once a day by automation, with, e.g., a trigger on the daily production sensor.
+1
More efficient than a query that will get (somewhat) slower over time with more data, but just make sure then that you don’t miss accumulating values.
As a workaround I’ve played a bit with the statistics graph and came up with this:
It sums the daily generated power by the tapo plug and shows it for the past 99999 days. Will this get slow or unreliable over time?
Energy
If you plot it or just query the current value? The former will, if you plot it for all of eternity, but it may not be noticeable in practical terms. It depends on a few things. For the latter, it would still just be a current state value, but keep in mind it could reset, depending on how that sensor is defined or by the integration that defines it.