Function: GreaterThan

Syntax

Code Block

language	none

GreaterThan(<FieldName|Function>, <Value|Function>)

Greater than 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 the second parameter.

Average duration of scripts with more than 10 steps:

Code Block

language	none

Faceted GreaterThan(ScriptStepCount,10) { Average(EstimatedDuration) } WHERE EntityType = Script

EstimatedDuration is greater than 5 minutes:

Code Block

language	none

Faceted GreaterThan(EstimatedDuration, '5 minutes') { COUNT } WHERE EntityType = Script

Script assignments where the last run has an actual duration that is greater than the estimated duration for the associated script:

Code Block

language	none

Faceted GreaterThan(ActualDuration, Field(EstimatedDuration)) { COUNT } WHERE EntityType = ScriptAssignment