I'm pulling data from the web api (yuck) of my solar inverters and a ZigBee HA 1.2 smart meter via a local connection to a Rainforest Eagle 3. There seems to be some offset between the data the two provide, because it will cause weird computed usage spikes. The most obvious issue with this is negative consumption (white dotted line), as I don't have any other power generating devices (no batteries or giant capacitor banks), but it's also resulting in weird super high usage spikes too (3.5 kW peak at about 15:00 in my image).
Is there a clean way for me to offset or average the data from one source or the other to make things line up?