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?