ES|QL STD_DEV function
number
The population standard deviation of a numeric field.
| number | result |
|---|---|
| double | double |
| integer | double |
| long | double |
FROM employees
| STATS std_dev_height = STD_DEV(height)
| std_dev_height:double |
|---|
| 0.2063704 |
The expression can use inline functions. For example, to calculate the population standard deviation of each employee’s maximum salary changes, first use MV_MAX on each row, and then use STD_DEV on the result
FROM employees
| STATS stddev_salary_change = STD_DEV(MV_MAX(salary_change))
| stddev_salary_change:double |
|---|
| 6.87583 |