somewhat fixed. I changed all historic entries to solar_day_energy_into_grid filtered and from_grid_filtered respectively.

Then removed the non-filtered entries from the energy board.

```
update statistics
set metadata_id = 150
where metadata_id = 128
and start_ts < 1677862800.0
;
update statistics
set metadata_id = 151
where metadata_id = 129
and start_ts < 1677862800.0
;
```

and adjusted the accumulated sums with values of the previous (unfiltered) sensors at time of handover.

```
update statistics
set sum = sum + 5141339
where metadata_id = 150
and start_ts >= 1677862799 --- 3.3. 17:00
and sum < 5142247 --- this line for safety only
;
update statistics
set sum = sum + 554817
where metadata_id = 151
and start_ts >= 1677862799
and sum < 554817 --- this line for safety only
;
```

and rectify the short_term statistics (check whether you need to set a date window here as well)

```
update statistics_short_term
set sum = sum + 5145293
where metadata_id = 150
;
update statistics_short_term
set sum = sum + 586090
where metadata_id = 151
;
```