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. experimental.mean() is an aggregate function.

import "experimental"

experimental.mean()

Parameters

tables

Input data. Default is piped-forward data (<-).

Examples

import "experimental"

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