How do I downsample data using multiple operations within the same bucket (in Influxdb 2.0)?

[Anaisdg]

Hello @Zane470,
You can specifying the measurement in the to() function. You would just need to write dummy data to that bucket first to initialize the measurement. You can construct a table and write it to the bucket first after adding a measurement.

TL;DR Tech Tips — How to Construct a Table with Flux

Then you can write the outputs do those measurements:

|> to(bucket: "some_bucket_downsampled", _measurement: "mean")

Alternatively you can create a task for each downsampled aggregation.

Also, please check out these resources as well:

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

How to Extract Values & Visualize Scalars with Flux and InfluxDB