Grafana can group time series by a column named metric.
So what you can do is put your host in select and name it metric:
SELECT temp, host AS metric
(…)
I got this info from Sven from the TimescaleDB-Slack-Community. All props to him.
1 Like