ES|QL SUM function
number
The sum of a numeric expression.
| number | result |
|---|---|
| aggregate_metric_double | double |
| double | double |
| exponential_histogram | double |
| integer | long |
| long | long |
| tdigest | double |
FROM employees
| STATS SUM(languages)
| SUM(languages):long |
|---|
| 281 |
The expression can use inline functions. For example, to calculate the sum of each employee’s maximum salary changes, apply the MV_MAX function to each row and then sum the results
FROM employees
| STATS total_salary_changes = SUM(MV_MAX(salary_change))
| total_salary_changes:double |
|---|
| 446.75 |