Two devices in one dashboard

Hi all,

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

Here's one of my queries that has multiple devices in the SELECT:

SELECT last("value") FROM "variable_changes" WHERE ("varname" = 'gone_to_bed' OR "varname" = 'guest_mode' OR "varname" = 'extended_away' OR "varname" = 'announcements_enabled' OR "varname" = 'alarm_enabled' OR "varname" = 'pushover_alarm_status') AND $timeFilter