Slimme meter remove unwanted data

[geertjanvz]

I know you can remove a faulty data entry by shift clicking in the graph. However this does not work in cumulative graphs like 'comparing usage.
My raspbery PI was offline for 3 months and after restarting the difference in usage in the past 3 months was added op to a new value.
Is there a way to correct this? I want to remove the high value. Perhaps by adding estimated values for the missing months.

[waltervl]

If you are brave enough you can use something like "DB Browser for SQLite": https://sqlitebrowser.org and modify and add values in the Calendar_meter table. But be sure you make a backup of your database!!!

[geertjanvz]

Indeed not for the faint hearted. I was hoping for an other route and avoiding SQL but I guess I'll have to dive deep .
Thanks

[waltervl]

With that SQLite browser you do not need to know SQL, you can add/edit database rows with a user interface.

[peterhnl]

Hi for the brave ones: I found this small tutorial very usefull: https://www.bjorn-meijer.nl/2021/05/08/ ... -database/
if you proceed with these kind of manipulations.

I have the same problem as geertjanvz. I already examined the MeterCalender table. However I can't find any monthly totals in this table.
Only day-totals which all seem OK to me, without any high values.
It's my theory these totals are periodically calculated (e.g stored procedure) and then written in an other table. Anyone?

[geertjanvz]

It's my theory these totals are periodically calculated (e.g stored procedure) and then written in an other table. Anyone?

I think that is indeed the case. You can however export the cumulative data from the chart to CSV. This might indicate that these calculated numbers are stored somewhere?