yesterday, my neo coolcam smartplug (z-wave) have 1 false reading, where it did send a kWh reading of 282.866,42 kWh, after this 1 bad reading it reported normal reading again. (that’s more then I use in 40+ years on the whole house)
but how do I delete that 1 bad reading ? my dashboard will reflect this bad reading when I use the month/year view ???
How have you installed home assistant and what are you using for the recorder integration?
Using the MyPHPAdmin addon I was able to delete readings from the statistics table in MariaDB - I had help with the SQL query though so unless you want to scroll through 1000s of reading you may need help with that.
Great thanks. I ended up finding this post which is essentially the same as yours but with a few extra details. Linking it here for anyone who might find this and want extra details:
Hm, this doesn’t seem to work for me. I’m deleting a single day but the wrongfully accumulated data just moves one day ahead. If I delete the 2nd of sep it shifts over to the 3rd and so on. Wanna avoid deleting the whole database just because on day of measurement went haywire
I’d say that’s because your sensor is of type “total_increasing”, meaning every reading is total, so you delete a day, the next day is still the total from the day before plus the daily use of that day.
You’d have to subtract the wrong reading from all subsequent reads.