Hello, I’m new to InfluxDB, I was trying to follow a guide online, but I got stuck on editing the script for the query.
It seems that I am using Version 2.7 so when it came to this part of the guide, I wasn’t sure how to implement it in the Query editor. I already have the SNMP, and data coming in, but this query here is different than I am using in InfluxDB 2.7
The code below is what I have gotten so far in the query in InfluxDB, and I get some measurements, but the guide above says to use some sort of math function that multiplies the values by 8, and then group it by a certain time. This is where I’m stuck now, I have commented out the map function that has the math part in it as I don’t think I’m doing that right, and also I need to figure out how much percentage of the 1GB speed is being used on this port.
Am I on the right track? Is there a particular setting or graph that I should be using?
import “contrib/jsternberg/influxdb”
import “math”
import “sampledata”
from(bucket: “Intelgraf”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r[“agent_host”] == “A.B.C.D”)
|> filter(fn: (r) => r[“ifDesc”] == “TwoGigabitEthernet1/0/1” and r[“_field”] == “ifHCOutOctets”)
|> derivative(nonNegative: true)
//|> map(fn: (r) => ({ r with newColumn: ( r._value ) * 8)})
|> aggregateWindow(every: 1s, fn: last)
