How to reset energy data after moving house?

[vivid citrus]

I have a Shelly Pro 3EM that I use to monitor the entergy in my house, using the total active energy sensor. I move a house so I did a reset on the Shelly app (Delete sensor data) to zero all history. On HA I delete the device and re-added it, and then I realized my mistake, where my energy showed a massive negative energy value (see attached pic).

From this point I tried reset the sensor history on HA but all attempts failed. What I tried was:

1. Tried using purge_entities action which gave an OK but didn't do anything. I used the following:

data:
  entity_id:
    - sensor.shelly_power_monitor_total_active_energy
  keep_days: 0   # 0 = delete all matching rows```

2. Tried renaming the entity and deleting/adding the device which did nothing, the history renamed.
3. Tried to adjust it via `developer tools -> statistics -> adjust sum` but it didn't mark the delete as an outlier so I couldn't find it and delete it.
4. Tried downloading `hestiia-engineering/hass_sql_request` to run something like `DELETE FROM states WHERE entity_id="sensor.shelly_power_monitor_total_active_energy";` but it also didn't work because after installation and restart I couldn't find the new `sql_request.delete action`

I would really appreciate some help in reseting the sensor and deleting all history. 
Thanks!

[terse brook]

You can simply move to the developer tools > statistics and then delete them all from there

Or only adjust the negative offset that it shows in your picture

[vivid citrus]

thanks, how do i delete them? I can't find the drop

[vivid citrus]

thank you! it indeed cleared the sum. However, the cost still shows a negative value, even when I tried removing it (do not track costs), or using a static price.

[terse brook]

The cost is stored separately, you likely will need to delete that one aswell