I’ve experimented with several sensors to measure engery, water and such. While doing this i got a lot of wrong sensor values, making the history look ugly. Is there a way to repair such things?
If these are statistics then you can try via devtools > statistics but I guess this is not.
Then the only way is in the db itself. Not sure what you are using as recorder but if this is the only set of data to repair then this is not too much and without SQL you can do this manually using a tool as dbbrowser (sqlite) of phpmyadmin (mariadb)
Nope… data is stored in teh db, both recent data as ‘history’ for as long as the data has not been purged (default 10 d) or long term statistics…which are kept in a much lower frequency and much longer (not wanting to say perpetual)
So, the only option is …tweak the db data…not for the fainthearted though but also no rocket science…what recorder do you have and/or do you know how to get to the db ?
Your picture all above shows values above 400 that were wrong, are we talking of the same ?
Also note that you are possibly looking history vs. statistics. History is kept for as long as the recorder is configured (default 10d), statistics much longer…hence I was asking if you wanted to correct statistics or history, seems to be the latter ? If it is the latter then this problem will resolve itself in hte next days (check your recorder settings)
History is in the states table and there you may find a lot more for the same sensor as it stores with every update.