My sensor data contains periodic anomalies. I could not find a way to delete specific datapoints, and I’m not sure if there is a command that solves my problem.
I want something like:
delete from <measurement> where <tag_name> = "<mytag>" and <field_name> > <myval>
AFAIK you can delete by tag or time range, but not by field.
I’ve thought about things like:
- dump the database, filter and reload
- dump the series, filter and reload
- adding a “status” tag (valid|invalid) and re-tagging invalid datapoints
- deleting the time-range with invalid data
What is the best strategy to remove out-of-range datapoints from my Influx database?