Calculate a weekly mean
This page documents an earlier version of InfluxDB. InfluxDB v2.7 is the latest stable version. View this page in the v2.7 documentation.
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
).
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 |
当前内容版权归 jasper-zhang 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 jasper-zhang .