So a couple of weeks ago i had a lightning strike at my house.
Lot’s of equipment was destroyed among a couple of energy meters.
One of them was my solar system energy meter.
So the meter was not long in place at all (around 3 months).
So what i did using some node-red and sql data, is copy the statistics from the old meter to the new one.
But this resulted in a big spike in data at the time of replacing the sensor. The counter value went from 695 kWh to 0.
What i figured would fix the problem would be to re calculate the sum values, so that the new meter would start at 0, and the sum counter values of the previous values would just be nagative.
This results in shifting the problem to the beginning of measurement. I now have a big negative energy delivery for one of my solar systems on the start date:
How would be my best approach to resolve this ?
