Data queries for Grafana dashboard tiles

data-tile-query.sql

-- TimeScaleDB
SELECT 
  time_bucket('180 seconds', bucket) AS agtime,
  AVG(avg) as "lab_indoor_temp"
FROM 
  timeseries_60s 
WHERE 
  $__timeFilter("bucket") AND
  tagname = 'lab_indoor_temp'
GROUP BY agtime
ORDER BY agtime ASC

-- InfluxDB
SELECT
  DATE_BIN(INTERVAL '180 seconds', time) AS time,
  avg(value) AS 'lab_indoor_temp'
FROM homedb
WHERE
  time >= $__timeFrom
  AND time <= $__timeTo
  AND sensor = 'lab_indoor_temp'
GROUP BY 1
ORDER BY 1