Function: Range
Syntax
Range(<FieldName|Function>, start, end)
Description
Range allows you to compare a field or the result of a function to a start and end value.
It will return true if the first parameter's value falls within the start and end values of the range.
Examples
Average estimated duration of scripts with between 10 and 20 steps:
Faceted Range(ScriptStepCount,10,20) { Average(EstimatedDuration) } WHERE EntityType = Script
Count of steps with an EstimatedDuration between 10 and 30 minutes:
Faceted Range(EstimatedDuration, '10m','30m') { COUNT } WHERE EntityType = Script