Define an Aggregate Expression
An Aggregate expression calculates an expression against child data in a relationship (example: Counting the number of Incidents linked to a Problem).
To define an Aggregate expression:
- Create an expression.
- In the
Editor drop-down list, select
Aggregate.
The Aggregate Expression section opens.
- Define the expression:
- In the
Relationship drop-down list, select a
relationship (example: Problem Has Linked Incidents).
Available relationships are based on the associated Business Object (example: Problem).
- In the
Function drop-down list, select the type
of data you want to retrieve:
- Count: Number of relationship occurrences (example: Number of linked Incidents).
- Total: Sum of a specified Numerical expression.
- Average: Average of a specified Numerical expression.
- Maximum: Highest returned value of a specified Numerical expression.
- Minimum: Lowest returned value of a specified Numerical expression.
- In the
Apply Against drop-down list
Token Selector, select the field or
Numerical expression for which you want to apply the expression. This option is
available for total, average, maximum, and minimum functions.
To create an impromptu custom expression, select New Custom Expression in the Token Selector.
- (Optional) Limit the returned data using an additional
expression:
- Select the
Limit check box.
The Limit fields become active.
- Select an expression:
- Stored Expression: Select the ellipsis button to open the Expression Manager, and then select an existing stored expression or create a new stored expression. You can reuse stored expressions in numerous places in CSM.
- Custom Expression: Select the Custom Expression button to open the Custom Expression Builder, and then create a custom expression specifically for this scenario.
- Select the
Limit check box.
- In the
Relationship drop-down list, select a
relationship (example: Problem Has Linked Incidents).
- Select Save.