I got today a huge spike in my solar energy production reported - see picture. The values of the sensor do not really support it - it actually seems like total value reported by the sensor was taken (as if the previous state was 0, which it was not). Any way reason/way to fix it?
After some more digging, it seems it was caused by a glitch in a sensor reporting the solar energy production. Any chance to drop the wrong value from the history somehow?
I will just answer myself, as I managed to fix it 
The problem was related to a single incorrect value of the sensor. I managed to install the SQLite Web add-on, locate the record in the states table and delete it. This fixed the sensor history, and I am hoping it will also be eventually taken into account by the Energy dashboard.
I needed to manually fix sum field in the respective statistics and statistics_short_term tables to actually fix the Energy dashboard. But once that is done - things seem to be back to normal
