This morning one of my aeotec multisensor 6 devices recorded a temperature over over 5,000 degrees C in our dining room. It wasn’t quite that hot, but I was wondering if there’s a way to remove that sort of corruption from the data.
Messes up the graph, albeit temporarily until my graph goes 36 hours old…
You can shutdown Home Assistant and then use a tool like DB Browser to run a SQL DELETE command for all values greater than a given threshold (like 5000).
I described the steps involved to someone else with a similar need to purge records from the database. It’s also applicable for your requirements:
Thanks, I’ll give it a go
