Since 3 weeks I have solar panels, and for the first 3 weeks, I put the P1 “energy returned” as the solar production, and have been collecting long term statistics in the energy panels. Of course, this looses the self-consumption energy.
As of today, I finally got around to setting up the modbus-tcp setup, so now I have proper solar production values.
When I modify the solar devices in the energy dashboard, of course no history from before today is displayed. So I would like to duplicate the P1_returned statistics to the solar_produced statustics for all historic values. Using SQL or somehing similar
Any suggestions on how, or where to start reading?