I am trying to visualize in one dashboard two devices (temps).
This is my query at the moment
- Code: Select all
SELECT mean("sensorValue") FROM "device_changes" WHERE ("name" = 'Temperatura Scala OG 1') AND $timeFilter GROUP BY time($interval) fill(null)
Basically I need two "WHERE", any hint?
Thanks
Marco