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)
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, the following resources are available:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.