---
title: Calculate a weekly mean
description: Calculate a weekly mean and add it to a new bucket.
url: https://docs.influxdata.com/influxdb/v2/process-data/common-tasks/calculate_weekly_mean/
estimated_tokens: 990
product: InfluxDB OSS v2
version: v2
publisher: InfluxData
canonical: https://docs.influxdata.com/influxdb/v2/process-data/common-tasks/calculate_weekly_mean/
date: '2023-09-12T23:33:31-06:00'
lastmod: '2023-09-12T23:33:31-06:00'
---

This page documents an earlier version of InfluxDB OSS.[InfluxDB 3 Core](/influxdb3/core/) is the latest stable version.

#### API token hashing is enabled by default in InfluxDB OSS 2.9.0

Stronger token security: tokens are stored as hashes on disk, so a
copy of the database file doesn’t expose usable tokens. Existing
tokens are hashed on first startup and the original strings can’t
be recovered afterward — **capture any plaintext tokens you still
need before you upgrade**.

For more information, see [Token hashing](/influxdb/v2/admin/tokens/#token-hashing).

> [!Note]
> This example uses [NOAA water sample data](/influxdb/v2/reference/sample-data/#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()`](/flux/v0/stdlib/universe/filter/) to select records with the `average_temperature` measurement.
* Uses [`range()`](/flux/v0/stdlib/universe/range/) to define the start time.
* Uses [`aggregateWindow()`](/flux/v0/stdlib/universe/aggregatewindow/) to group records by week and compute the mean.
* Sends the weekly mean to a new bucket (`weekly_means`).

```js
option task = {
  name: "weekly-means",
  every: 1w,
}

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

### Example results

|      \_start       |       \_stop       |\_field|   \_measurement    |  location   |     \_value     |       \_time       |
|--------------------|--------------------|-------|--------------------|-------------|-----------------|--------------------|
|2019-09-01T11:24:00Z|2020-10-19T20:39:49Z|degrees|average\_temperature|coyote\_creek|80.31005917159763|2019-09-05T00:00:00Z|
|2019-09-01T11:24:00Z|2020-10-19T20:39:49Z|degrees|average\_temperature|coyote\_creek|79.8422619047619 |2019-09-12T00:00:00Z|
|2019-09-01T11:24:00Z|2020-10-19T20:39:49Z|degrees|average\_temperature|coyote\_creek|79.82710622710623|2019-09-19T00:00:00Z|

|      \_start       |       \_stop       |\_field|   \_measurement    |  location   |     \_value     |       \_time       |
|--------------------|--------------------|-------|--------------------|-------------|-----------------|--------------------|
|2019-09-01T11:24:00Z|2020-10-19T20:39:49Z|degrees|average\_temperature|santa\_monica|80.19952494061758|2019-09-05T00:00:00Z|
|2019-09-01T11:24:00Z|2020-10-19T20:39:49Z|degrees|average\_temperature|santa\_monica|80.01964285714286|2019-09-12T00:00:00Z|
|2019-09-01T11:24:00Z|2020-10-19T20:39:49Z|degrees|average\_temperature|santa\_monica|    80.20451     |                    |

[tasks](/influxdb/v2/tags/tasks/)
| _start | _stop | _field | _measurement | location | _value | _time |
| --- | --- | --- | --- | --- | --- | --- |
| _start | _stop | _field | _measurement | location | _value | _time |
| 2019-09-01T11:24:00Z | 2020-10-19T20:39:49Z | degrees | average_temperature | coyote_creek | 80.31005917159763 | 2019-09-05T00:00:00Z |
| 2019-09-01T11:24:00Z | 2020-10-19T20:39:49Z | degrees | average_temperature | coyote_creek | 79.8422619047619 | 2019-09-12T00:00:00Z |
| 2019-09-01T11:24:00Z | 2020-10-19T20:39:49Z | degrees | average_temperature | coyote_creek | 79.82710622710623 | 2019-09-19T00:00:00Z |

| _start | _stop | _field | _measurement | location | _value | _time |
| --- | --- | --- | --- | --- | --- | --- |
| _start | _stop | _field | _measurement | location | _value | _time |
| 2019-09-01T11:24:00Z | 2020-10-19T20:39:49Z | degrees | average_temperature | santa_monica | 80.19952494061758 | 2019-09-05T00:00:00Z |
| 2019-09-01T11:24:00Z | 2020-10-19T20:39:49Z | degrees | average_temperature | santa_monica | 80.01964285714286 | 2019-09-12T00:00:00Z |
| 2019-09-01T11:24:00Z | 2020-10-19T20:39:49Z | degrees | average_temperature | santa_monica | 80.20451 |  |