experimental.mean() function

The experimental.mean() function computes the mean or average of non-null values in the _value column of each input table. Output tables contain a single row the with the calculated mean in the _value column.

Function type: Aggregate
Output data type: Float

import "experimental"

experimental.mean()

Examples

import "experimental"

from(bucket:"example-bucket")
  |> filter(fn: (r) =>
    r._measurement == "example-measurement" and
    r._field == "example-field")
  |> range(start:-1h)
  |> experimental.mean()