Calculate a weekly mean

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.

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_measurementlocation_value_time
2019-09-01T11:24:00Z2020-10-19T20:39:49Zdegreesaverage_temperaturecoyote_creek80.310059171597632019-09-05T00:00:00Z
2019-09-01T11:24:00Z2020-10-19T20:39:49Zdegreesaverage_temperaturecoyote_creek79.84226190476192019-09-12T00:00:00Z
2019-09-01T11:24:00Z2020-10-19T20:39:49Zdegreesaverage_temperaturecoyote_creek79.827106227106232019-09-19T00:00:00Z
_start_stop_field_measurementlocation_value_time
2019-09-01T11:24:00Z2020-10-19T20:39:49Zdegreesaverage_temperaturesanta_monica80.199524940617582019-09-05T00:00:00Z
2019-09-01T11:24:00Z2020-10-19T20:39:49Zdegreesaverage_temperaturesanta_monica80.019642857142862019-09-12T00:00:00Z
2019-09-01T11:24:00Z2020-10-19T20:39:49Zdegreesaverage_temperaturesanta_monica80.20451

Was this page helpful?

Thank you for your feedback!