Unexplained energy spikes on home assistant dashboard (even when using utility meters & other workarounds)

Ey everyone,

Getting a weird issue in my home assistant energy dashboard that I really don't know how to solve...

I sometimes get a spike in energy reading from a group of devices "Jasmijn Office Energy" (this is a group helper that does sum across different utility meters that connect to energy sensors of smart plugs).

This happens when I f.e. restart home assistant because of an update. BUT the weird thing is: I have the same setup for other groups (Timo Office Energy, Living Room Entertainment Energy, ...) and there the spikes don't happen..

I see that all these groups become temporarily unavailable when f.e. restarting home assistant, but why does only this 1 helper group have an impact on the energy dashboard?

Fixed -> The utility meter had "delta_values" enabled, which should have been disabled. Because it was enabled, whenever the sensor dropped out and got back again, its value got added to the utility meter, while the value of the sensor was already the total energy value.

I had several of these spikes in my home assistant dashboard due to misconfiguration or sensors dropping out, so wrote a script to detect and solve them, see github repo here: homelab-monorepo/homeassistant/scripts at main · TimoVerbrugghe/homelab-monorepo · GitHub