experimental.stddev() function

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
• population

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