Energy consumption and production values went wonky somehow

My production and consumption sensor values (which are read from the Sense integration), went to 0 for some reason (presumably because the service couldn’t be reached), and that caused my energy usage graphs to go all screwy. Can I manually edit something to get things back to normal?


I assure you, I neither produce nor consume this much energy :slight_smile:

You have to edit the statistics and meta tables in the home assistant recorder database.

Anyone know how to do that? I’ve removed the offending rows from the states table in the regular database, but I get the feeling that this component pulls data from wherever historical statistics comes from.

Not the states table, these tables:

Screenshot 2021-10-06 at 13-12-26 Supervisor - Home Assistant