I have a Aeotec Heavy Duty Smart Switch (bought for a suspiciously low price, but I now think I understand why).
It shows huge spikes in consumption on average a couple of times per day (more frequently on days where actual consumption is high). Ridiculous amounts like 100kwh in a 5 min period.
The size of these spikes makes it easier to remove them via “Adjust a statistic” in Developer tools.
However it would be convenient to have a way to do this automatically. E.g. if a value is bigger than 3kwh in an [ x ] minute period, set it to 0.
That is sound advice. One question though, if the spikes are in statistics/energy dashboard only but not the sensor itself, then the most likely cause is the sensor going to 0 when it should have been unavailable. If you have a template sensor in between you can fix it by setting an availability template, if not then the outlier filter may still fix it and if not then there other ways too.
Anyway: setting it to 0 when the value is wrong is not the answer for kWh sensors!
Edwin_D, I believe the problem is in the sensor itself. I can’t check the the energy data now since I’ve removed all the outliers. However looking at the power entity, I see spikes of e.g. 1MW, instead of going to zero.
brooksben11, thanks, this seems like the right solution. I’ll try it this weekend.