---
title: Query cumulative sum
description: Use the cumulativeSum() function to calculate a running total of values.
url: https://docs.influxdata.com/influxdb/cloud/query-data/flux/cumulativesum/
estimated_tokens: 445
product: InfluxDB Cloud (TSM)
version: cloud
publisher: InfluxData
canonical: https://docs.influxdata.com/influxdb/cloud/query-data/flux/cumulativesum/
date: '2025-04-02T15:54:32-06:00'
lastmod: '2025-04-02T15:54:32-06:00'
---

Use the [`cumulativeSum()` function](/flux/v0/stdlib/universe/cumulativesum/)to calculate a running total of values.`cumulativeSum` sums the values of subsequent records and returns each row updated with the summed total.

**Given the following input table:**

|\_time|\_value|
|------|-------|
| 0001 |   1   |
| 0002 |   2   |
| 0003 |   1   |
| 0004 |   3   |

**`cumulativeSum()` returns:**

|\_time|\_value|
|------|-------|
| 0001 |   1   |
| 0002 |   3   |
| 0003 |   4   |
| 0004 |   7   |

> [!Note]
> The examples below use the [example data variable](/influxdb/cloud/query-data/flux/#example-data-variable).

##### Calculate the running total of values

```js
data
    |> cumulativeSum()
```

## Use cumulativeSum() with aggregateWindow()

[`aggregateWindow()`](/flux/v0/stdlib/universe/aggregatewindow/)segments data into windows of time, aggregates data in each window into a single
point, then removes the time-based segmentation.
It is primarily used to [downsample data](/influxdb/cloud/process-data/common-tasks/downsample-data/).

`aggregateWindow()` expects an aggregate function that returns a single row for each time window.
To use `cumulativeSum()` with `aggregateWindow`, use `sum` in `aggregateWindow()`,
then calculate the running total of the aggregate values with `cumulativeSum()`.

```js
data
    |> aggregateWindow(every: 5m, fn: sum)
    |> cumulativeSum()
```

#### Related

* [cumulativeSum() function](/flux/v0/stdlib/universe/cumulativesum/)

[query](/influxdb/cloud/tags/query/)[cumulative sum](/influxdb/cloud/tags/cumulative-sum/)
| _time | _value |
| --- | --- |
| _time | _value |
| 0001 | 1 |
| 0002 | 2 |
| 0003 | 1 |
| 0004 | 3 |

| _time | _value |
| --- | --- |
| _time | _value |
| 0001 | 1 |
| 0002 | 3 |
| 0003 | 4 |
| 0004 | 7 |