Cant fix long term statistics

[neat whale]

One of my entities with energy information has strange values in January. But when i go the statistics to fix this, i cant find any suspicious values at that time. How can i fix this issue?

[earnest sparrow]

So the adjust sum dialog will never affect the value shown in that history graph.
Those values are not adjustable.

Total-type statistics record two datapoints per hour, a state and a running sum.
Sum is what's used in energy dashboard, and what's changed by Adjust dialog.

The history graph just shows state and that never changes.

[foggy oracle]

I have this issue also, I cant adjust historic values depite fixing the issue in the 'adjust a stat' dialog. Is there a way to amend historic stats?

[slow stone]

No

Just the statistics

[foggy oracle]

wow, that's a pretty fundamental problem. you cant be expected to catch all these errors and fix them before they become historic? they must exist 'somewhere' in the db

[earnest sparrow]

Yes they all exist in the DB and you can edit them if you know how to navigate your db of choice

there's just no UI to do so.

[slow stone]

Is it? You are not meant to keep states longer than a few weeks anyway

Things like continuous sums can reset

And integrations that consume long term data will use the statistics

Like the energy dashboard

[foggy oracle]

Exactly the energy dashboard, for some reason I have had sporadic occurrences of meters reading the entire amount (e.g. year-to-date) for one day, I assume due to a restart or upgrade the meter temporarily reads 0 before getting its true state of x000kWh and then that is attributed to that day, ruining historic energy statistics

[slow stone]

Yes, so you can correct those errors

But its better to figure out what's causing the issue

[foggy oracle]

My daily meter is derived from the running total meter (total increasing) values, I assume this is causing the issue, but I dont know why. Editing the DB scares me 😄