SELECT mean(“value”) FROM “mqtt_consumer” WHERE (“topic” = ‘esp32/sensors/dsTemp1’) AND timeFilter GROUP BY time(__interval) fill(linear)
I offer you the same answer as I gave in response when you asked the same
question on the Grafana list 6 hours ago:
SELECT mean(“value”) FROM “mqtt_consumer” WHERE (“topic” =
‘esp32/sensors/dsTemp1’) AND “value” != -127 AND timeFilter GROUP BY
time(__interval) fill(linear)
Antony.