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, the function assumes the absolute delta between two points is at least their non-negative difference.

Function type: Aggregate
Output data type: Float

increase(columns: ["_values"])



The list of columns for which the increase is calculated. Defaults to ["_value"].

Data type: Array of strings


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

Function definition

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

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

Need help getting up and running? Get Support