I have a problem with gaps in the statistics. My energy meter (total consumption) had reading errors for several days and the meter reading was entered in the statistics with the old status.
Now that the meter reading is being read correctly again, the interim consumption is added to the first day with plausible values.
Looking in the statistics table you see that there are rows on Jan 2nd having the old (not updated) sensor value as state.
I know that it is possible to correct one particular datapoint. But how can I smooth out the spike on Jan 3rd and have the values of the missing gap interpolated?
I found some topics discussing SQL statements but non of them told me how to do the maths to update the existing datasets with the right calculated values.