Hello all,
I’m trying to create a single query statement to Influx to calculate the percentage of utilization using the “select” statement and the “Show Tag Value” statement.
The following queries work individually however, I can’t figure out how to combine the two. All the examples I found dealt with two “field values”, not with a field and tag value…
The example queries shows the results from single interface/port from a network router.
Query 1:
SELECT max(traffic_in) FROM “interface_util” WHERE time > now() - 10m and unique_id=‘ABC_123’
Query 1 returned value = 43491168304
Query 2:
SHOW TAG VALUES from “interface_util” WITH KEY IN (“If_speed”) WHERE time > now() -10m and unique_id=’ABC_123’
Query 2 returned value = 60000000000
Thank you in advance…
