How to remove 1 reading in the energy dashboard

[Protechtedd (Andrew)]

Great thanks. I ended up finding this post which is essentially the same as yours but with a few extra details. Linking it here for anyone who might find this and want extra details:

Energy Management - full data reset?

This process worked for me to ninja-delete a specific days worth of data due to a haywire sensor. Just a nutshell for anyone who might want to take an easier route and simply delete all the energy data of a specific day, this query will work: DELETE FROM "statistics" WHERE "created" like '2021-09-16%' Of course change the date itself, but leave the % symbol, as it is the wildcard (since the timestamp is always different). You can delete only a specific sensor instead of a whole day by more c…