Skew

InfluxDB 2.0 sum multiple fields

Feb 7th, 2021
607
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. from(bucket: "kraken")
  2. |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  3. |> filter(fn: (r) => r["_measurement"] == "kraken")
  4. |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value")
  5. |> map(fn: (r) => ({ _time: r["_time"], _value: r["ADA"] + r["BTC"] + r["DOT"] + r["ETH"] + r["KSM"] + r["LINK"] + r["UNI"] + r["USD"] }))
  6. |> aggregateWindow(every: v.windowPeriod, fn: mean, createEmpty: false)
  7. |> yield(name: "mean")
Advertisement
Add Comment
Please, Sign In to add comment