experimental.stddev() function

The experimental.stddev() function is subject to change at any time. By using this function, you accept the risks of experimental functions.

The experimental.stddev() function computes the standard deviation of non-null values in the _value column for each input table. experimental.stddev() is an aggregate function.

import "experimental"

experimental.stddev(mode: "sample")



The standard deviation mode or type of standard deviation to calculate. Defaults to "sample".

Available options:


Calculate the sample standard deviation where the data is considered to be part of a larger population.


Calculate the population standard deviation where the data is considered a population of its own.


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


import "experimental"

from(bucket: "example-bucket")
    |> range(start: -5m)
    |> filter(fn: (r) => r._measurement == "cpu" and r._field == "usage_system")
    |> experimental.stddev()

Was this page helpful?

Thank you for your feedback!

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.