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 output

Was this page helpful?

Thank you for your feedback!

Linux Package Signing Key Rotation

All signed InfluxData Linux packages have been resigned with an updated key. If using Linux, you may need to update your package configuration to continue to download and verify InfluxData software packages.

For more information, see the Linux Package Signing Key Rotation blog post.