---
title: Calculate the increase
description: Use increase() to track increases across multiple columns in a table. This function is especially useful when tracking changes in counter values that wrap over time or periodically reset.
url: https://docs.influxdata.com/influxdb/v2/query-data/flux/increase/
estimated_tokens: 521
product: InfluxDB OSS v2
version: v2
publisher: InfluxData
canonical: https://docs.influxdata.com/influxdb/v2/query-data/flux/increase/
date: '2025-04-02T15:54:32-06:00'
lastmod: '2025-04-02T15:54:32-06:00'
---

This page documents an earlier version of InfluxDB OSS.[InfluxDB 3 Core](/influxdb3/core/) is the latest stable version.

#### API token hashing is enabled by default in InfluxDB OSS 2.9.0

Stronger token security: tokens are stored as hashes on disk, so a
copy of the database file doesn’t expose usable tokens. Existing
tokens are hashed on first startup and the original strings can’t
be recovered afterward — **capture any plaintext tokens you still
need before you upgrade**.

For more information, see [Token hashing](/influxdb/v2/admin/tokens/#token-hashing).

Use [`increase()`](/flux/v0/stdlib/universe/increase/)to track increases across multiple columns in a table.
This function is especially useful when tracking changes in counter values that
wrap over time or periodically reset.

```js
data
    |> increase()
```

`increase()` returns a cumulative sum of **non-negative** differences between rows in a table.
For example:

**Given the following input:**

|       \_time       |\_value|
|--------------------|-------|
|2020-01-01T00:01:00Z|   1   |
|2020-01-01T00:02:00Z|   2   |
|2020-01-01T00:03:00Z|   8   |
|2020-01-01T00:04:00Z|  10   |
|2020-01-01T00:05:00Z|   0   |
|2020-01-01T00:06:00Z|   4   |

**`increase()` returns:**

|       \_time       |\_value|
|--------------------|-------|
|2020-01-01T00:02:00Z|   1   |
|2020-01-01T00:03:00Z|   7   |
|2020-01-01T00:04:00Z|   9   |
|2020-01-01T00:05:00Z|   9   |
|2020-01-01T00:06:00Z|  13   |

#### Related

* [increase() function](/flux/v0/stdlib/universe/increase/)

[query](/influxdb/v2/tags/query/)[increase](/influxdb/v2/tags/increase/)[counters](/influxdb/v2/tags/counters/)
| _time | _value |
| --- | --- |
| _time | _value |
| 2020-01-01T00:01:00Z | 1 |
| 2020-01-01T00:02:00Z | 2 |
| 2020-01-01T00:03:00Z | 8 |
| 2020-01-01T00:04:00Z | 10 |
| 2020-01-01T00:05:00Z | 0 |
| 2020-01-01T00:06:00Z | 4 |

| _time | _value |
| --- | --- |
| _time | _value |
| 2020-01-01T00:02:00Z | 1 |
| 2020-01-01T00:03:00Z | 7 |
| 2020-01-01T00:04:00Z | 9 |
| 2020-01-01T00:05:00Z | 9 |
| 2020-01-01T00:06:00Z | 13 |