Aggregate List

Last update: Edit

1 Introduction

The Aggregate list activity can be used to calculate aggregated values over a list of objects. The aggregated values supported by this activity are:

  • average
  • count
  • maximum
  • minimum
  • sum

2 Properties

An example of aggregate list properties is represented in the image below:

aggregate list properties

There are two sets of properties for this activity, those in the dialog box on the left, and those in the properties pane on the right.

The aggregate list properties pane consists of the following sections:

3 Action Section

The Action section of the properties pane shows the action associated with this activity.

You can open a dialog box to configure this action by clicking the ellipsis () next to the action.

You can also open the dialog box by double-clicking the activity in the microflow or right-clicking the activity and selecting Properties.

3.1 List

The name of the list to aggregate.

3.2 Function

Defines which type of aggregation is applied.

Value Description
Average The average of all values of an attribute from the list of objects.
Count The total number of objects in the list.
Minimum The minimum of all values of an attribute from the list of objects.
Maximum The maximum of all values of an attribute from the list of objects.
Sum The sum of all values of an attribute from the list of objects.

3.3 Attribute

Defines which attribute of the objects in the list is used to aggregate over. This must be a numeric attribute (Long, Integer, or Decimal).

3.4 Variable Name

The name of the variable in which the result of the aggregation is stored. This variable will have a numeric data type that depends on the selected function.

4 Common Section

For more information on properties in this section, see Common Properties.