Returns the sample variance of data, an iterable of at least two real-valued numbers. Variance is a measure of the variability (spread or dispersion) of data. A large variance indicates that the data is spread out; a small variance indicates it is clustered closely around the mean.
If no time window is provided it returns the variance of the series.
variance([ts])
| Arguments | Description |
|---|---|
| ts (optional) | Time window. |
A float value.
# Select the variance grouped by 1 minute
select variance(1m) from "series-001"