How to do multiple aggregation (min, max, mean) together using Flux query?

[Anaisdg]

This might be useful:

Multiple Aggregation Projections in fluxql

There are a few things they could do. Union and pivot two streams: |> range(start: -1d) |> filter(fn: (r) => r._field == "temp") temp_mean = data |> mean() |> set(key: "_field", as: "temp_mean") num_points = data |> count |> set(key: "_field", as: "num_points") union(tables: [temp_mean, num_points]) |> pivot(rowKey:["_time"], columnKey: ["_field"], valueColumn: "_value") Use reduce to create a custom aggregate that does both at the same time: data = from(bucket: "example-bucket") |> …