Remove super high sensor value

Hi all,

I have a Speedtest integration set up to measure the speed of my internet connection.

A few weeks ago, I was doing some maintenence work and appearantly, it completed the test but the ping was super high, which now causes the entie data to be useless since I can’t make out the difference between 1ms and 10ms anymore.

How do I remove this datapoint? It’s not under dev tools-> statistics. I also know a little bit of SQL and I’m not afraid of trying something with help of someone in here, but I’m a bit scared I will ruin the ±3 years of speedtest history with this datapoint.

You can only edit sensors with state class total or total_increasing in the Developer Tools Statistics panel.

SQL is the only way.

Create a full backup and move it off your system before proceeding.