You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Current »

Function: LessThan

Syntax

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

Description

The LessThan 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 the second parameter.

Examples

Average duration of scripts with less than 20 steps:

Faceted LessThan(ScriptStepCount,20) { Average(EstimatedDuration) } WHERE EntityType = Script

EstimatedDuration is less than 5 minutes:

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

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

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

See Also

  • No labels