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

[fly161932]

I am trying to transfer a InfluxQL query to Flux query but find it really hard to do multiple aggregation (min, max, mean) together using a Flux query:

SELECT MIN() AS MinValue, MAX() AS MaxValue, MEAN() AS AverageValue FROM … WHERE Time >= ‘2020-07-25T22:13:38Z’ and Time <= ‘2020-07-25T22:18:38Z’ GROUP BY FILL(none);

Can someone please help? Or direct me to the correct documention/example showing how to do min/max/mean together in Flux?

[FixTestRepeat]

Still getting my head around flux as well. I asked a similar question last week and Scott suggested this method to do it (and it’s been working well!)

How to plot median and 95th percentile within same cell?

Hi, I am struggling to wrap my brain around getting flux + Chronograf to visualize more than one series. Eg, how can I get both the median and the 95th percentile as separate series, but plotted on the same chart? This is the documentation page I’ve been referencing. For a single series, it works fine, but every attempt with multiple series has given an error Edit: something equivalent to this [image]

[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") |> …