'InfluxDB Flux - only show values over a certain %
I am using InfluxDb with Grafana and I am only wanting it to show values over a certain %. Any ideas how I could do this.
|> range(start: v.timeRangeStart, stop: v.timeRangeStop)
|> filter(fn: (r) => r["_measurement"] == "vsphere_datastore_disk")
|> filter(fn: (r) => r["_field"] == "capacity_latest" or r["_field"] == "used_latest")
|> filter(fn: (r) => r["source"] =~ /.*/)
|> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
|> map(fn: (r) => ({ r with _value: float(v: r.used_latest) / float(v: r.capacity_latest) * 100.0 }))
|> group(columns: ["source","_field"])
|> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
|> yield(name: "mean") ```
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
