Huge amount of energy returned on a specific day

[jfroy]

Huge amount of energy returned on a specific day

[magico13]

Two questions: what sensor are you using for the energy dashboard? And what day is your "Billing Date" set to in the Emporia app?

If you use the one month sensor and the date is the 11th then that could be the source of the problem. If you use the 1D sensor can you show me what the graph for that sensor looks like for the 10th through the 12th ( at least the 24 hours of the 11th but some buffer on both sides might help).

Even if we can't find what caused that big drop, you should be able to fix that if it's just one bad statistics input. There's a built-in statistics editor, I'll find the link.

The link to get to that page should be https://{your-home-assistant-address}:8123/developer-tools/statistics

You'd find that sensor that has bad data, then click the "adjust sums" button on the right and find the date/time that had the big jump, then edit that. How it should be edited depends on what the graphs look like, it might just need to be set to 0 or there might be some other value that would be better.

And here's the link to the release notes for that stats adjustment feature, since it's not well documented anywhere else: https://www.home-assistant.io/blog/2022/04/06/release-20224/#adjusting-long-term-statistics

[jfroy]

I am using the "1,2,3 1D" sensor. The billing day is set to the 1st of the month.

[jfroy]

I think I maybe know what happened. I did a bunch of maintenance work in HA around that date and I definitely did a full purge of my recorder database:

service: recorder.purge
data:
  keep_days: 0
  repack: true

I am guessing that's what screw it up.

[magico13]

That definitely sounds like it could affect the stats. I don't see anything out of the ordinary with that graph, so I would probably just try to fix the statistics manually and keep an eye on it if you do a purge like that again.

[jfroy]

Nuked the bad stats. Thanks for the help.