Zero total increasing energy sensor

[foonji (Michael)]

Hi all,

I’ve tried searching but haven’t found anything to assist me in working out how I can zero the data on a total increasing energy sensor. Why you ask? Well I’ve been playing with getting my solar data into HA via MODBUS and now I’m at a stage where I’m not playing and want to have it start fresh.

I’ve read that a negative input will reset it, but I don’t see how this will work as the input will never be negative. Is there another way that I can force this?

Thanks

[tom_l]

Editing the database id an option if you know SQL. Otherwise the nuclear option is to delete the entire database (and thus all your history data) and restart to reform it.

[foonji (Michael)]

Thanks for the response Tom - I can dabble a little, I was able to clear the HA Energy data successfully earlier, but didn’t have much luck trying to drill down to the sensor data. Broke it and restored from a backup

[Bartem]

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…