How can I filter data which non equal "-127"

please help complete the request
it is necessary to remove values equal to -127
display all others

SELECT mean(“value”) FROM “mqtt_consumer” WHERE (“topic” = ‘sensors/dsTemp1’) AND timeFilter GROUP BY time(__interval) fill(linear)

Well, how about:

SELECT mean(“value”) FROM “mqtt_consumer” WHERE (“topic” = ‘sensors/dsTemp1’)
AND “value” != -127 AND timeFilter GROUP BY time(__interval) fill(linear)

?

Antony.

1 Like

works
thank
just tweaked the request a bit:

SELECT mean(“value”) FROM “mqtt_consumer” WHERE (“topic” = ‘sensors/dsTemp1’) AND “value” != -127 AND timeFilter GROUP BY time(__interval) fill(linear)