experimental.stddev() function

experimental.stddev() is subject to change at any time.

experimental.stddev() returns the standard deviation of non-null values in the _value column for each input table.

Standard deviation modes

The following modes are avaialable when calculating the standard deviation of data.


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.

Function type signature
(<-tables: stream[{A with _value: float}], ?mode: string) => stream[{A with _value: float}]
For more information, see Function type signatures.



Standard deviation mode or type of standard deviation to calculate. Default is sample.

Available options:

  • sample
  • population


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


Return the standard deviation in input tables

import "experimental"
import "sampledata"

    |> experimental.stddev()

View example input and ouput

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.