Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Query for Velocidad de download - Media:
- from(bucket: "<bucket>")
- |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
- |> filter(fn: (r) => r["_measurement"] == "exec_speedtest")
- |> filter(fn: (r) => r["_field"] == "download_bandwidth")
- |> filter(fn: (r) => r["host"] == "raspberrypi")
- |> map(
- fn: (r) => ({
- _time: r._time,
- _measurement: r._measurement,
- _field: r._field,
- _host: r._host,
- _value: float(v: r._value) / 125000.0
- }),
- )
- |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
- |> yield(name: "mean")
- Query para Velocidad de download maxima (cambia la ultima funciona para min si quieres la minima):
- from(bucket: "<bucket>")
- |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
- |> filter(fn: (r) => r["_measurement"] == "exec_speedtest")
- |> filter(fn: (r) => r["_field"] == "download_bandwidth")
- |> filter(fn: (r) => r["host"] == "raspberrypi")
- |> map(
- fn: (r) => ({
- _time: r._time,
- _measurement: r._measurement,
- _field: r._field,
- _host: r._host,
- _value: float(v: r._value) / 125000.0
- }),
- )
- |> max(column: "_value")
- Query historical velocidad de bajada (cambia "download_bandwidth" para "upload_bandwidth" para velocidad de subida):
- from(bucket: "<bucket>")
- |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
- |> filter(fn: (r) => r["_measurement"] == "exec_speedtest")
- |> filter(fn: (r) => r["_field"] == "download_bandwidth")
- |> filter(fn: (r) => r["host"] == "raspberrypi")
- |> map(
- fn: (r) => ({
- _time: r._time,
- _measurement: r._measurement,
- _field: r._field,
- _host: r._host,
- _value: float(v: r._value) / 125000.0
- }),
- )
Advertisement
Add Comment
Please, Sign In to add comment