Spurious energy spikes in HA data.

4 comments started 2025-02-06 last 2025-02-06
Home AutomationHome Assistant
B
#1 browellm

In January I had three days where my sensors glitched, reporting massive battery and energy use stats. This is screwing with my stats. Is there a way for me to easily find these in the database and edit them out by overwriting the figures with a nominal 'average'?

For reference, these are the sensors I use for my energy chart. Posting these if for some reason they aren't the ones to be using.

G
#2 geoffreycoan

browellm Developer Tools / Statistics search for the name of your sensor, click on the little uphill icon on the right, then you can search for the date/time with the anomoly or click ‘outliers’ to be presented with values that HA thinks could be eroneous

Repeat for each issue. The results are shown immediately in the Energy dashboard.

You can manually work out the correct values from the HA portal meter data for the hour that’s wrong, or just set to zero

B
#3 browellm

geoffreycoan Chapeau, Geoffrey <3