Hello there,
I am using the energy Dashboard for years now.
Over the years, I used different methods of tracking my energy consumption from and to the grid.
When I switched the entity in the dashboard from my Inverter (not that accurate, sadly) to the smart meter, my grid company uses, to bill me, I lost all history that was based on the inverter.
I couldn’t use it in parallel, though, as the inverter would still deliver new data and that would double everything.
Now I’m not sure if the device I use at the moment (tibber pulse) to collect the data from the smart meter, will work much longer, as I changed my contract to another company. So I fear to loose all history in the energy dashboard again, if I switch to another device.
I already have another IR sensor to track the consumption (from HomematicIP) lying around here. I just didn’t install it yet, out of fear to loose everything again.
Now I’m looking for a good solution to merge all these different sources together. I already checked and all the data is still available in the statistics database of homeassistant (using the SQLite Addon).
So this should be possible. I’m just not sure how…
I guess I have to create a helper entity, and then copy all entries from the inverter up until I installed the tibber pulse, then all data from the tibber pulse up until I eventually switch to the HomematicIP device (HmIP-ESI-IEC) onto this single helper entity.
Is this the way you would do that, or are there any other tipps?
I’m also looking for correct pricing data, of course. During my 1,x years with tibber I had dynamic pricing, before and after that, the prices were fixed.
I guess it should be able to copy the pricing data, too?
That data seems to be available in the history, too as the name of the entity, recording the consumption, with “_cost” as a suffix?
To add to that: My day-job deals around databases, so the code is not the problem. It’s more the concept for the best solution, that I’m not entirely sure about ;).
Is my Idea with a new helper entity that I add all 3 Sources to and let it itself collect data from the currently active sensor (so probably soon the HomematicIP one) the best way, or are there simpler or otherwise better solutions?
Thank you all in advance!
