Range (Range)

Function: Range


Range(<FieldName|Function>, start, end)


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.


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

See Also