I have an error in the database

[Teunhen]

i have an error in the database and i dont know how to edit it away. anyone that can help me with it? im hoping to get my stats back to normal.

[tom_l]

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…

[Teunhen]

I have been trying to put that solution to work but i didnt get that result to be fixed. But maybe its because i dont really understand sql databases.