I am new to influxdb and i just want to visualize air quality sensor data.
Sometime the sensor give false data due to high humidity or wind gust, so i would like to know how to ignore or exclude certain values, (higher than xy) in the dashboard of influxdb?
Measurement data is coming every 15 minutes from node red. Latest version of influxdb.
Welcome @rancho
If the data is truly false, you could of course filter it using Node-RED and just never send those false readings to InfluxDB.
But since they are already in InfluxDB (and deleting data from InfluxDB is not easy), you could use a filter function like this:
|> filter(fn: (r) => r._value > xy)
