Utility Meter - Value on Total Consumption from last week is wrong - How to fix it?

Configuration
1

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

2

Developer tools > Statistics. Click on the little ramp icon for your entity that needs adjusting.

Also you need to fix the sensor that feeds the utility meter so that it reports unavailable rather than 0 when it is offline to prevent this happening again.

3

Many Thanks.

I was able to fix it now using your advice.

I didn’t change the configuration yet but is something that I will need to look at later to avoid this same issue in similar scenarios.

Thanks a lot.

GoodWeather

4

I have same sort of issue but the sensor doesn’t have this ramp like icon but I see it with others. What makes the difference ?

5

The state_class.