Function: GreaterThanOrEqual
Syntax
Code Block | ||
---|---|---|
| ||
GreaterThanOrEqual(<FieldName|Function>, <Value|Function>) |
Description
The GreaterThanOrEqual 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 greater than or equal in value to the second parameter.
Examples
Average duration of scripts with 10 or more steps:
Code Block | ||
---|---|---|
| ||
Faceted GreaterThanOrEqual(ScriptStepCount,10) { Average(EstimatedDuration) } WHERE EntityType = Script |
EstimatedDuration is greater than or equal to 10 minutes:
Code Block | ||
---|---|---|
| ||
Faceted GreaterThanOrEqual(EstimatedDuration, '10 minutes') { COUNT } WHERE EntityType = Script |
Script assignments where the last run has an actual duration that is equal to or greater to the estimated duration for the associated script:
Code Block | ||
---|---|---|
| ||
Faceted GreaterThanOrEqual(ActualDuration, Field(EstimatedDuration)) { COUNT } WHERE EntityType = ScriptAssignment |