In fact, it’s not quite that simple.
I used the GUI DBeaver for that. But you need to read some small intros / tutorials about the basics. Otherwise you could easily destroy your DB 
. Therefore always make a backup of your DB !
to get a rough overview about the steps:
-
stop HA to prevent any write access to the DB while editing
-
find the ID of your statistics of interests in table statistics_meta - in my case the total energy counter to (56) and from (55) the power grid
-
filter the table statistics with that id and find the abnormality in the sum column
-
calculate an offset value which added will result in the correct sum and apply this offset to all following sum entries
-
do the same with the table statistic_short_term (otherwise HA will revert you changes after start
) -
apply your changes to each table by the save button on the bottom of the table
-
start HA - and hopefully the energy dashboard is restored
