Function: LessThanOrEqual
Syntax
LessThanOrEqual(<FieldName|Function>, <Value|Function>)
Description
The LessThanOrEqual function allows you to compare the value of a field or function to a fixed value, another field or a function.
It will return true if the first parameter is less than or equal to the second parameter.
Examples
Average duration of scripts with less than or equal to 30 steps:
Faceted LessThanOrEqual(ScriptStepCount,30) { Average(EstimatedDuration) } WHERE EntityType = Script
EstimatedDuration is less than or equal to 5 minutes:
Faceted LessThanOrEqual(EstimatedDuration, '5 minutes') { COUNT } WHERE EntityType = Script
Script assignments where the last run has an actual duration that is less than or equal to the estimated duration for the associated script:
Faceted LessThanOrEqual(ActualDuration, Field(EstimatedDuration)) { COUNT } WHERE EntityType = ScriptAssignment