Remove incorrect value from history

[Alexey_HA_newbie]

Hello. Is is somehow possible to remove this 0 V value from History? I tried to remove it both from statistics and statistics_short_term database, but no changes in graph happened

I’ve found topics like this but no help there

Automation to remove values from history

Hello there, I’m using a temp/humidity sensor in Bluetooth. Sometimes, the value is not realistic, like yesterday, my office went from 21.2°C to 1568.7°C and back to 21.0°C. It is easy to detect with an automation that the difference between last value and current value is weird with a template for exemple. But then, I’d like to remove that non-sense value from the states table in a way. Is it possible? Because if I dont, my graph look like this [image] which is not really nice … EDIT: …

Remove dips in a history graph

Thank you, I will look into this according to your tips. // Flagg

[mekaneck (Rick Auch)]

That data point is in the states table, which contains every state change going as far back as your recorder database purge settings are set to (10 days by default). If you’ve already fixed the data in the statistics table, you could just wait 10 days for it to disappear. Otherwise you’ll have to use some SQL commands to get rid if it. Be cautious of looking at older posts for help; the database has been restructured a few times in the past, so SQL commands in older threads won’t work any more.

[Alexey_HA_newbie]

Thanks. I have purge interval set to 365 days. Will wait forever Thanks exactly what i’m looking for - those magic SQL commands to do something with this graph except removing data from statistics tables (done already like i said earlier)