Grafana
snr
from(bucket: "meshcore") |> range(start: v.timeRangeStart, stop: v.timeRangeStop) |> filter(fn: (r) => r._measurement == "meshcore_trace") |> filter(fn: (r) => r._field == "snr") |> group(columns: ["gateway", "from", "to"])
status
from(bucket: "meshcore")
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r._measurement == "meshcore_trace_status")
|> filter(fn: (r) => r._field == "success")
|> map(fn: (r) => ({ r with _field: r.path }))
|> drop(columns: ["path", "host"])