increase() function

The increase() function calculates the total non-negative difference between values in a table. A main use case is tracking changes in counter values which may wrap over time when they hit a threshold or are reset. In the case of a wrap/reset, we can assume that the absolute delta between two points will be at least their non-negative difference.

Function type: Aggregate
Output data type: Float

increase(column: "_values")

Parameters

column

The column for which the increase is calculated. Defaults to "_value".

Data type: Strings

Examples

from(bucket: "telegraf/autogen")
  |> range(start: -24h)
  |> filter(fn: (r) =>
    r._measurement == "system" and
    r._field == "n_users"
  )
  |> increase()

Given the following input table:

_time _value
00001 1
00002 5
00003 3
00004 4

increase() produces the following table:

_time _value
00002 4
00003 7
00004 8

Function definition

increase = (tables=<-, column="_value") =>
	tables
		|> difference(nonNegative: true, column:column)
		|> cumulativeSum()

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


Need help getting up and running? Get Support