Hi,
I have an Home Assistant with Utility Meter configuration running very well for the last 6 months.
Last week I got a power cut from weather conditions and I realize today that the Power Consumption on the power cut day (13th June 2022) which was between 10-20kWh in daily basis went to 125829.12 kWh on that day.
With this, my weekly, monthly and yearly statistics now show kWh and Electricity costs way up from what should be.
Now trying to fix the issue in HA database (SQLite) and traced the wrong update done by the sensor in the databse in the STATE table:
Step1 - Installed the SQLite WEB to access the HA database
Step2 - Did an update to the STATE table to fix the record which was showing the sensor state as 125829.12kWh and update it to show the normal kWh at that time which was 4063.39kWh.
With this Step2 I was expecting to have the Energy Dashboard in the Daily level showing the right kWh for that 13th June 2022 but the Dashboard is still showing the old 125829.12kWh value.
Is there a easy way to fix this issue?
Thanks in advance.
GoodWeather