experimental.stddev() function
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.
Function type: Aggregate
Output data type: Float
import "experimental"
experimental.stddev(mode: "sample")
Parameters
mode
The standard deviation mode or type of standard deviation to calculate.
Defaults to "sample"
.
Data type: String
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.
Examples
import "experimental"
from(bucket: "example-bucket")
|> range(start: -5m)
|> filter(fn: (r) =>
r._measurement == "cpu" and
r._field == "usage_system"
)
|> experimental.stddev()
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, the following resources are available:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.