Delete one whole day in energy dashboard or fix values for one day

Energy
22

yes yes, i understand you, that HA takes the value out of a random source…

but the sources are limited… memory and db …

memory should be empty when HA is shout down…

because of the DB i tested this:

UPDATE `states` SET `state`= 2080.060 WHERE metadata_id = 960 AND `state_id` > 127340768;

UPDATE `statistics` SET `state`= 2100.282 WHERE metadata_id = 334 AND start_ts > 1709096300;

UPDATE `statistics` SET `sum`= 2076.824 WHERE metadata_id = 334 AND start_ts > 1709096300;

UPDATE `statistics_short_term` SET `state`= 2100.282 WHERE metadata_id = 334 AND start_ts > 1709276700;

UPDATE `statistics_short_term` SET `sum`= 2076.824 WHERE metadata_id = 334 AND start_ts > 1709276700;

meaning no more 38 at states, statistics and statistic_shot_therm…

but on reboot of HA state is now 39.091…

so we have 3 tables cleared with the data… we cleared the memory by shut down HA…

what could be the fith storage for the 38 ?

or its magic :smiley:

23

It’s HA, so the sources for data are infinite, and equal to the number of things you can hack.
But if you ask me, the answer is (almost) 42.
So long and thanks for all the fish.
:dolphin:

24

Hello,
I had the same problem and found how to solve this issue.
If you modify the “sum” data in the table statistics you absolutly need to also correct the data in the table “statistics_short_term”.
The “statistics_short_term” is used to generate the new hour data in the table statistics.
Hope this help others people having the same problem.
Regards,
Nicolas

PS: no need to stop or restart HA before of after the database modification. You can do this online with the SQlite HA plugin