Energy Dashboard historical data issue

[b4ker]

Hi All,

hope someone can help me to solve my issue.
I played around with my tasmota energy sensor and accidently published wrong values.
this is my sensor from the customize.yaml

sensor.stromzaehler_mt681_total_in:
  state_class: total_increasing
  device_class: energy
  icon: mdi:home-import-outline
  unit_of_measurement: kWh

due to the wrong published values, I destroyed my whole historical data for energy consumption.

now it counted that I consumed 32 kWh today, which is obviously not right…

what I already did:
I already deleted the 2 wrong values in the SQL database for this sensor, so if I check the logs everything looks fine:

but for any reason if I click on the sensor directly I still see the wrong values as in the first screenshot and also the issue is still present in the energy dashboard.

Does anyone have any idea what I can do to solve it. Where is the data stored for the energy dashboard?
I don’t want to delete the whole database and lose all the history only due to this stupid issue…

Thanks in advance.

[b4ker]

Hi all,

I was able to fix this following this instructions:

How to fix statistics data (e.g. energy data)

Hey I have managed (I think) to solve the issue which was bothering me for a long time and I have decided to share the solution with you guys. I hope that someone finds it helpful. Problem I have OWL energy sensor which sends the data via RF433. The problem is that sometimes the received values are not correct. Pretty often I get “0” as the energy_total and once the value jumped significantly by 78M. [image] I don’t have the sensor data to investigate what has happened that day and what wer…

Thanks everyone anyway