I’m using InfluxDB 1.7 and I have a use case where I need to extract the higher value of two fields.
e.g. These two queries will give highest RX and TX for the specified time interval. Visualisation is a table.
Query1: SELECT top(“ifOutBits_rate”, “ifName”, 20) FROM “ports”
Query2: SELECT top(“ifInBits_rate”, “ifName”, 20) FROM “ports”
Is there a way to filter this further and get only the higher of the two queries in the table? 4.90 Gbps for Ethernet1/1 and 4.94 Gbps for Ethernet 1/2 in the example. I’m basically trying to get highest interface utilization rate rx or tx