stateDuration() function

The stateDuration() function computes the duration of a given state. The state is defined via the function fn. For each consecutive point for that evaluates as true, the state duration will be incremented by the duration between points. When a point evaluates as false, the state duration is reset. The state duration is added as an additional column to each record.

*Function type: Transformation
**
Output data type:* Duration

As the first point in the given state has no previous point, its state duration will be 0.

  1. stateDuration(fn: (r) => r._measurement == "state", column: "stateDuration", unit: 1s)

If the expression generates an error during evaluation, the point is discarded, and does not affect the state duration.

Parameters

Make sure fn parameter names match each specified parameter. To learn why, see Match parameter names.

fn

A single argument function that evaluates true or false to identify the state of the record. Records are passed to the function. Those that evaluate to true increment the state duration. Those that evaluate to false reset the state duration.

*Data type: Function*

column

The name of the column added to each record that contains the state duration.

*Data type: String*

unit

The unit of time in which the state duration is incremented. For example: 1s, 1m, 1h, etc. The default unit is one second (1s).

*Data type: Duration*

Examples

  1. from("monitor/autogen")
  2. |> range(start: -1h)
  3. |> filter(fn: (r) => r._measurement == "http")
  4. |> stateDuration(
  5. fn: (r) => r.http_response_code == "500",
  6. column: "server_error_duration"
  7. )

Related articles