How to delete value range in InfluxDB/Grafana?

[Joo01]

Hi,

On creating a utility meter I did a failure and get some too higher values from a wrong source.
After correcting the source, the wrong values remain in the DB and I have no idea how to delete them without deleting the correct values. But no matter what I try, the values in the InfluxDB simply cannot be deleted.
I have to delete all values before April 1st.

The DELETE run into error

Maybe someone can help me and tell me what I’m doing wrong.

Thanks

[tom_l]

InfluxDB: Removing or deleting data

I submit this to assist others who may ned to know how to delete data from InfluxDB via the InfluxDB UI in HASSIO. Go to explore and query for the following SHOW MEASUREMENTS ON "<db_name> eg: homeassistant" SHOW TAG KEYS ON "<db_name>" FROM "<measurement_name> eg: °C" Query template: USE "<***db_name***>"; DELETE FROM "<***measurement_name***>" WHERE "<***tag***>" = '***tag_value***' AND time < '2021-04-04' Actual query eg: USE "homeassistant"; DELETE FROM "°C " WHERE "entity_id" = 'tas…

[Joo01]

Thanks a lot!
Found also the thread here:

InfluxDB: Removing or deleting data

That is to be expected. Your query only deletes measurements, it does not return any.

That query helped me (I was very close ):
DELETE FROM "kWh" WHERE ("entity_id"='hausstrom_zahler_monat') AND time <= '2023-03-31 21:59:10'

[Wingnut (Graham Richards)]

It’s not working for me. I get the same error put in the original post.

my SQL is…

DELETE FROM "homeassistant"."autogen"."°C" WHERE time > :dashboardTime: AND time < :upperDashboardTime: AND ("entity_id"='boiler_cabinet_temperature')