How to delete BAD DATA from a table

as you know Influx is not a SQL database and it has its own rules, look at the key concepts here

you can’t edit your data after inserting them, therefore you can’t add tags to filter your delete, unless they are already present.

but I got another idea, you can override an existing value if you know the key of the point (series + timestamp) by just making an insert with the new field value. if appropriate you can override/update your data with 0.