Hi, I have the following code for outputing the jitter in Flux. All of it is in just one query (A) in grafana:
import “math”
entryA = from(bucket:“telegraf”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop )
|> filter(fn: (r) => r.host== “PRG-Vmontes-VElisa” )
|> filter(fn: (r) => r.name == “www.google.com”)
|> filter(fn: (r) => r._measurement == “ping” and r._field == “average_response_ms”)
|> aggregateWindow(every: 5m, fn: mean)
|> set(key: “status”, value:“present”)
|> yield(name: “A”)
entryB = from(bucket:“telegraf”)
|> range(start: v.timeRangeStart, stop: v.timeRangeStop )
|> filter(fn: (r) => r.host== “PRG-Vmontes-VElisa” )
|> filter(fn: (r) => r.name == “www.google.com”)
|> filter(fn: (r) => r._measurement == “ping” and r._field == “average_response_ms”)
|> aggregateWindow(every: 5m, fn: mean)
|> timeShift(duration: 5m, columns: [“_time”])
|> set(key: “status”, value:“future”)
|> yield(name: “B”)
final = union(tables: [entryA,entryB])
|> pivot(rowKey: [“_time”], columnKey: [“status”], valueColumn: “_value”)
|> map(fn: (r) => ({r with _value: float(v: r.present) }))
|> map(fn: (r) => ({r with _value: float(v: r.future) }))
|> toFloat()
|> map(fn: (r) => ({r with _value: ( r.future - r.present) }))
|> filter(fn: (r) => (r._value > -100 ))
|> map(fn: (r) => ({r with _value: math.abs(x: r._value ) }))
final
The output that I get is the one in the picture below
the light blue line is the one that matters since that is my jitter. The thing I want is to only output that value (variable “final”).
Can anyone tell me how i can output just this value? I would like to use it for other mathematical operations and equations to calculate the quality of my ISP.
