Hello I have an issue with the energy dashboard. on Sept. 10, something seems to have gone wrong with the analysis of power and gas data. As a result, there are incorrect values in my summary [3] Can I still correct this error? I installed phpMyAdmin to access the MariaBD. In the homeassistan…

Go to Developer Tools → Statistics. Find your sensor and click on the little ramp icon to the right. Navigate to the date and time of the issue and change the value(s) to an average of whatever came before and after. Then investigate what is causing this issue and fix it so it does not happen aga…

Thank you @anon11644107 , it worked great for me… I asked the same question a couple of months ago and I got an answer which was to edit configuration file of HA… and of course I did not edit those files…too risky… Your solution to correct the data is safe and quick… Thanks again !

Thank you so much! Everything looks smooth again :smiley:

Thank you also Mark I have successfully applied Tom’s method

Now you need to work out why it happened to stop it happening again. Look at the history graph for the energy sensor at the time it happened. What does it look like?

At that time there was a power failure I can’t link it to anything else at the moment, but keep an eye on it

Show the history graph of the energy sensor at that time. My guess is that it is going to 0 rather than unavailable. State changes from <total_energy> → unavailable → <total_energy> are not registered by the energy dashboard. State changes from <total_energy> → 0 → <total_energy> will be register…

I only keep the history of sensors for 1 week So unfortunately I can’t provide you the data?

It worked for me some weeks ago. However, I tried to fix a value yesterday in the same statistics and it didn’t work anymore. Was there a change in HA?

Saved my day! Here is another solution, but way more complicated :smile: [image] How to fix statistics data (e.g. energy data) Community Guides Hey I have managed (I think) to solve the issue which was bothering me for a long time and I have decided to share t…

Many of my sensors don‘t have the ramp in statistic and I wonder why one sensor has this featureand others not?

Change energy dashboard values

Configuration

Nevs88 (Sven Jachalke) February 25, 2023, 5:54pm 13

Saved my day!
Here is another solution, but way more complicated