I have time data in InfluxDB with pairs of hostnames (field “host”) and CPU temperatures (field “temp”).
I’ve set up nine queries - one for each host - like this:
Now, every time I add a new host, I need to modify this panel to make a new query. What if I would just like to select all temperature measurements, delete the WHERE host=… clause, and group the results by host? In ordinary SQL, I would use the GROUP BY clause to group by the field “host”, but I can’t do this in Grafana, since GROUP BY only allows time.
Is what I want possible with Grafana?