Documentation

hourSelection() function

The hourSelection() function retains all rows with time values in a specified hour range.

Function type: Transformation

hourSelection(
  start: 9,
  stop: 17,
  timeColumn: "_time"
)

Parameters

start

The first hour of the hour range (inclusive). Hours range from [0-23].

Data type: Integer

stop

The last hour of the hour range (inclusive). Hours range from [0-23].

Data type: Integer

timeColumn

The column that contains the time value. Default is "_time".

Data type: String

Examples

Use only data from 9am to 5pm
from(bucket:"example-bucket")
  |> range(start:-90d)
  |> filter(fn: (r) => r._measurement == "foot-traffic" )
  |> hourSelection(start: 9, stop: 17)

New! Cloud or OSS?

InfluxDB OSS 2.0 now generally available!

InfluxDB OSS 2.0 is now generally available and ready for production use. See the InfluxDB OSS 2.0 release notes.

For information about upgrading to InfluxDB OSS 2.0, see: