cumulativeSum() function

The cumulativeSum() function computes a running sum for non-null records in the table. The output table schema will be the same as the input table.

_Function type: Transformation
*Output data type: Float*

cumulativeSum(columns: ["_value"])

Parameters

columns

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

*Data type: Array of strings*

Examples

from(bucket: "example-bucket")
  |> range(start: -5m)
  |> filter(fn: (r) =>
    r._measurement == "disk" and
    r._field == "used_percent"
  )
  |> cumulativeSum(columns: ["_value"])

Related articles

• Query cumulative sum
• InfluxQL – CUMULATIVE_SUM()