I have an integration sensor for an old solar inverter thatI don’t have anymore, since a few months. However, I still want to keep the data around for at least one year, for comparison. Starting recently, the sensor has been resetting to zero each night or after each HA restart, instead of keeping its old value.
I tried setting the integral type from left to trapezoidal, but nothing changed:
My only resort for now is to run update "statistics" set sum=1685.4699999999996 where metadata_id=6 and created_ts>1739559610.2355804 every time this happens, which is not ideal. Not sure if there are any other ways.