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)