Energy data corrupt due to wrong data in "statistics" table?

[cuball]

I have been running the Energy dashboard for a few days. Everything was fine, until recently the graphics were corrupt.

I had a look in the tables and I found this strange data in statistics table. Some range of the values for “sum” are negative for my total_yield of my PV entity, but only a few Not all of them…

Any idea what could be the reason ? Can I recalculate these values so that it’s correct again ?

[liudger (Willem-Jan)]

I had something similar

Remove faulty readings from energy dashboard history

I had something similar with my statistics. A sensor was giving wrong values, api request from server was 0 instead of total. I think there was some server maintenance. The next values where correct and the sum was just adding the value difference from 0 to the new correct lifetime energy. This was a huge amount. The problem is that the statistics should not have negative delta’s allowed from lifetime energy solar panels. It will never be negative. So I am not sure where the fix needs to be mad…

I think the statistics need some smarter logic for lifetime energy readings.