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!

Introducing InfluxDB 3.0

The new core of InfluxDB built with Rust and Apache Arrow. Available today in InfluxDB Cloud Dedicated.

Learn more

State of the InfluxDB Cloud Serverless documentation

The new documentation for InfluxDB Cloud Serverless is a work in progress. We are adding new information and content almost daily. Thank you for your patience!

If there is specific information you’re looking for, please submit a documentation issue.