I have a power monitor on my solar immersion heater controller. Only been running a few days and it is keeping track of the power usage.
I also set up an integration sensor that totals the energy in kWh (got to bout 20kWh). I got a bad data point which instantaneously added 30kWh to the state of the integration sensor making the graph and totals meaningless.
I have followed another guide to edit the SQL database of statistics and statistics_short_term. All should be well except the ongoing integration sensor remains at the 50kWh level. Is there any way I can force this to the 20kWh level in line with the database?