Docs

v2.0

sum() function

The sum() function computes the sum of non-null records in specified columns.

Function type: Aggregate
Output data type: Integer, UInteger, or Float (inherited from column type)

sum(columns: ["_value"])

Parameters

columns

Specifies a list of columns on which to operate. Defaults to ["_value"].

Data type: Array of strings

Examples

from(bucket: "telegraf/autogen")
  |> range(start: -5m)
  |> filter(fn: (r) =>
    r._measurement == "cpu" and
    r._field == "usage_system"
  )
  |> sum()

SUM()


Bug Reports and Feedback

Thank you for being willing to help test InfluxDB v2.0 alpha! Feedback and bug reports are welcome and encouraged both for InfluxDB and this documentation.

Submit feedback in the InfluxData Community