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:

  1. Create an expression.
  2. In the Editor drop-down list, select Aggregate.
    The Aggregate Expression section opens.
  3. Define the expression:
    1. 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).
    2. 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.
    3. 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.
    4. (Optional) Limit the returned data using an additional expression:
      1. Select the Limit check box.

        The Limit fields become active.

      2. Select an expression:
        • Stored Expression: Select the ellipsis button Ellipses 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 Expression Button to open the Custom Expression Builder, and then create a custom expression specifically for this scenario.
  4. Select Save.