docs-v2/content/influxdb/v1/flux/guides/increase.md

1.6 KiB

title seotitle list_title description weight menu list_query_example canonical v2
Calculate the increase Calculate the increase in Flux 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. 10
influxdb_v1
parent name
Query with Flux Increase
increase /influxdb/v2/query-data/flux/increase/ /influxdb/v2/query-data/flux/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:

{{< flex >}} {{% flex-content %}} 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
{{% /flex-content %}}
{{% flex-content %}}
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
{{% /flex-content %}}
{{< /flex >}}