How to fix wrong data in Energy?

[petrho (Peter)]

Sometimes I get wrong data in the energy so the correct data will be extremly small bar charts. How can I take away the faulty data point without delete the .db2 file (whole database)?

[tom_l]

Recalculate statistics table sum to fix wrong energy data

I’ve been having some issues with the Energy data due to switching from Shelly integration to using MQTT. The sensors I configured over MQTT were sending the wrong data, causing wrong data in the statistics table for those days. My issue in particular was that the new sensors (which I gave the same name as the shelly sensors to keep the history) were sending data in watt-minutes instead of kWh, resulting in a very small ‘state’ number and increasing the sum value by a lot. This causes spikes in …

[petrho (Peter)]

I’m using the EV charger (Easee) integration. However I am interested how to fix this IF it occurs.