Is it possible to query a metrics of host1 and host2 and display the largest?

Telegraf
,
1

Is it possible to query a metrics of host1 and host2 and display the largest?

I need to do this to use with 1 traffic light dashboard.

Ex. CPU host1, CPU host2
When either of them reaches 90% the traffic light will turn red.

2

@Rafael_Braganca,
What version of influx are you using? Can you please share what your schema looks like? You can use the max() function and run the following Influxql query to return the max value across those two tags:
SELECT max("usage_system") AS "max_usage_system" FROM "telegraf"."autogen"."cpu" WHERE time > :dashboardTime: AND ("host"='host1' OR "host"='host2')

Or you can use Influx 1.7.6+ with Flux and do the following query which will return two max values, one for each host.

In Flux it would look like from(bucket: "telegraf") |> range(start: -1d) |> filter(fn: (r) => r.host == "host1" or r.host == "host2") |> filter(fn: (r) => r._field == "usage_system") |> max()