Help! Weird blip on gas usage in Statistics table

A few days ago I got a huge blip in my gas consumption with a really strange consumption number. I have tried to fix the statistics table with both the developer statistics features and update queries to the actual table. I can get the statistics table looking properly but at the start of every new hour, the blip reoccurs.

If I add the value of the blip to all the sum values in the statistics table, I can move the blip to the start of the values. If I just subtract the value from the latest sum figure, it shows back up at the top of the hour. How do I correct this data? Where is Home Assistant holding on to this number so that I can adjust it?

Found it! statistics_short_term also needed fixed.

I think if I had used the developer/statistics tool from the start, everything would have been fine. I jumped straight to the tables with update queries. Next time, I’ll try to just use the built in tool.