Hi,
Kinda lost and looking for some help. I added a watermeter to my config but I forgot to add the correct watermeter value, so I corrected that in the end. This resulted in using 500.000 liters of water in one day. I tried to correct the states but they keep going back to their original value. I think the only way is to edit the database entries and remove the faulty ones. Or better, start over and remove all of them. Is there an easy way of doing this? I’m running HA on Odroid.
For removing all database entries from a specific entity, you can use the service recorder.purge_entities
Navigate to Developer Tools ➞ Services ➞ recorder.purge_entites ➞ select entity_id
I have the same issue
I am running Home Assistant OS on a Raspberry PI
I have 2 Athom Smart Plug TP29 running on ESPHome
due to exploding energy costs I plan to buy some more as it is very helpful to monitor certain devices or groups of devices
now I am stuck in purging all data from those Athom Smart Plugs
I read a lot and installed already SQLlite Add-On, I can connect to the DB and see tables, I have installed SSH Add-On and connect via cli
but that is about it 
please bare with me, but I am not really firm in cli neither sqllite
than I came across recorder.purge_entities
I choose the athom and HASS offers to split the devices into all its entities
and than click purge
but nothing happens old data is still in db
I appreciate any help and would be really greatful if one of the pros here would sacrifice some minutes and take me by the hand
I would love to delete ALL Data of an Athom Smart Plug so when re-adding it to the energy-dashboard it starts as if never known to the system with all sensors 0