Documentation

experimental.stddev() function

Flux 0.107.0+

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")

Parameters

mode

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

Available options:

sample

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

population

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

tables

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

Examples

import "experimental"

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

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.