Range (Range)

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

See Also