Calculate a weekly mean

This example uses NOAA water sample data.

This example calculates a temperature weekly mean and stores it in a separate bucket.

The sample query performs the following operations:

• Uses filter() to select records with the average_temperature measurement.
• Uses range() to define the start time.
• Uses aggregateWindow() to group records by week and compute the mean.
• Sends the weekly mean to a new bucket (weekly_means).

1. option task = {
2. name: "weekly-means",
3. every: 1w,
4. }

6. from(bucket: "noaa")
7. |> filter(fn: (r) => r._measurement == "average_temperature")
8. |> range(start: 2019-09-01T11:24:00Z)
9. |> aggregateWindow(every:  1w, fn: mean)
10. |> to(bucket: "weekly_means")

Example results

tasks