Avarage multiple measurements

Grafana InfluxDB
1

I have 4 measurements of temperature from different inputs in InfluxDB:
SELECT last(temperature) FROM “ServerSensorA”
SELECT last(temperature) FROM “ServerSensorB”
SELECT last(temperature) FROM “ServerSensorC”
SELECT last(temperature) FROM “ServerSensorD”

How can I graph (or display gauge) as avarage of all of them ?

2

Now its upto you. Do you want to display all one single dashboard or one by one or you want to introduce one variable which helps you to select one by one dashboard.

Like when you select " ServerSensorA" only dashboard shows you the data which belongs to this server.

3

Sorry, maybe you missunderstood my question:

I would love to COMBINE all 4 measurements and display only one, single AVARAGE value of them all.

How can i combine them all into one, single AVARAGE value ?

Influxdb does not support math operations across multiple measurements so no luck there. I was hoping that Grafana would be helpful enough to do such calculation.

4

Do you mean this in influx?

SELECT mean(“last”)
FROM
(SELECT last(temperature) FROM “ServerSensorA”),
(SELECT last(temperature) FROM “ServerSensorB”),
(SELECT last(temperature) FROM “ServerSensorC”),
(SELECT last(temperature) FROM “ServerSensorD”)

5

You could try the Blendstats plugin.