range() function

The range() function filters records based on time bounds. Each input table’s records are filtered to contain only records that exist within the time bounds. Records with a null value for their time are filtered. Each input table’s group key value is modified to fit within the time bounds. Tables where all records exists outside the time bounds are filtered entirely.

Function type: Transformation
*Output data type: Object

range(start: -15m, stop: now)

Parameters

start

The earliest time to include in results. Use a relative duration or absolute time. For example, -1h or 2019-08-28T22:00:00Z. Durations are relative to now().

Data type: Duration | Time

stop

The latest time to include in results. Use a relative duration or absolute time. For example, -1h or 2019-08-28T22:00:00Z. Durations are relative to now(). Defaults to now().

Data type: Duration | Time

Time values in Flux must be in RFC3339 format.

Examples

Time range relative to now
from(bucket:"telegraf/autogen")
  |> range(start:-12h)
  // ...
Relative time range
from(bucket:"telegraf/autogen")
  |> range(start:-12h, stop: -15m)
  // ...
Absolute time range
from(bucket:"telegraf/autogen")
  |> range(start:2018-05-22T23:30:00Z, stop: 2018-05-23T00:00:00Z)
  // ...

WHERE

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


Need help getting up and running? Get Support