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.

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

This documentation is open source. See a typo? Please, open an issue.


Need help getting up and running? Get Support