Two devices in one dashboard

Posted on
Sun Nov 19, 2023 10:21 am
MarcoGT offline
Posts: 1033
Joined: Sep 11, 2014
Location: Germany

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?


Posted on
Sun Nov 26, 2023 4:48 pm
vtmikel offline
Posts: 608
Joined: Aug 31, 2012
Location: Boston, MA

Re: Two devices in one dashboard

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

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 2 guests