Calculate the increase

Use the increase() function 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.

  1. data
  2.   |> 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:00Z1
2020-01-01T00:02:00Z2
2020-01-01T00:03:00Z8
2020-01-01T00:04:00Z10
2020-01-01T00:05:00Z0
2020-01-01T00:06:00Z4

increase() returns:

_time_value
2020-01-01T00:02:00Z1
2020-01-01T00:03:00Z7
2020-01-01T00:04:00Z9
2020-01-01T00:05:00Z9
2020-01-01T00:06:00Z13

Related articles

query increase counters