Function: Range
Syntax
| Code Block | ||
|---|---|---|
| ||
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:
| Code Block | ||
|---|---|---|
| ||
Faceted Range(ScriptStepCount,10,20) { Average(EstimatedDuration) } WHERE EntityType = Script
|
Count of steps with an EstimatedDuration between 10 and 30 minutes:
| Code Block | ||
|---|---|---|
| ||
Faceted Range(EstimatedDuration, '10m','30m') { COUNT } WHERE EntityType = Script
|