Recalculate statistics table sum to fix wrong energy data

[e-raser]

@Renekcl

Frustrating that there is no easy way to fix wrong values in the statistics.

Statistics fixing MIGHT be easy. Have a look at the /developer-tools/statistics page. Example:

That seems to fix tables statistics and statistics_short_term (but not table states).

Energy dashboard screwed due to decreasing input sensor - how to a) fix and b) prevent in future?

Today it happened to me too… energy dashboard screwed due to sensor fault in “grid usage” input sensor. I accidentally noticed this: [grafik] I can’t have negative values. Only taking power from the grid currently. This input senor is generated using this yaml: energy_total_total: friendly_name: Stromverbrauch Alle Gesamt unit_of_measurement: "kWh" value_template: >- {{ ( states('sensor.energy_1_total') | float(0) + …