hourSelection() function

hourSelection() filters rows by time values in a specified hour range.

Function type signature

(
    <-tables: stream[A],
    start: int,
    stop: int,
    ?location: {zone: string, offset: duration},
    ?timeColumn: string,
) => stream[A] where A: Record

Parameters

start

(Required) First hour of the hour range (inclusive). Hours range from [0-23].

stop

(Required) Last hour of the hour range (inclusive). Hours range from [0-23].

location

Location used to determine timezone. Default is the location option.

timeColumn

Column that contains the time value. Default is _time.

tables

Input data. Default is piped-forward data (<-).

Examples

Filter by business hours

data
    |> hourSelection(start: 9, stop: 17)