Aggregate data

The Aggregate data action node is used to perform aggregations on data in Data connectors. It is available in both Apps and Services.

Examples

Count with no grouping

In this example, no groupings or filters are applied. The chosen operator is Count, and the value should be written to the Count property of the Target Data Source. Note that the Count operator does not require a property to aggregate by. The result is one object in the data source Order aggregates (temp) with Count equal to the total number of Orders.

Average with one grouping

In this example, the Orders are grouped by the Customer property. The Customer value is written to the Customer property of the Target Data Source. The chosen operator is Average, and the property to aggregate by is the Amount of each Order. The value should be written to the Average property of the Target Data Source. This will create one object for each unique Customer that is represented in the Orders Data Connector. The objects are stored in the data source Order aggregates (temp) with Average equal to the average Order Amount for that customer.

Sum with multiple groupings

In this example, the Orders are grouped by the Customerand Status properties. The Customer and Status values are written to the Customer and Status properties of the Target Data Source. The chosen operator is Sum, and the property to aggregate by is the Amount of each Order. The aggregation result should be written to the Sum property of the Target Data Source. This will create one object for each unique combination of values of Customer and Status that are present in the Orders Data Connector. The objects are stored in the data source Order aggregates (temp) with Sum equal to the sum of Order Amounts for that combination of Customer and Status.

Properties

Property	Description
Data Connector	Select a data source of type data connector to perform aggregations on.
Selection	Define the objects to aggregate. All objects Filtered selection
Filter	Available when Filtered Selection is selected. Define the filter to apply to the data connector.
Sorting	Add sorting rules. The objects will be sorted before the grouping and aggregations are performed.
Target Data Source	Specify a runtime-only data source or service variable to place the resulting data in.
Operation	Select how existing objects in the Target Data Source will be treated. If the Target Data Source is a service variable the operation will be limited to Update single cardinality object. Replace All Objects: Remove any existing objects before creating the objects. Update single cardinality object: Update the selected property in the existing object. Add to Data Source (merge duplicates): Keep any existing objects.
Group By	Only available if the Target Data Source is many-cardinality. Optionally select one or more properties to group the data by and which property to write the group value to. This will create one aggregation per unique value of the selected property, and thus create multiple objects in the Target Data Source.
Aggregations	Add aggregations. For each aggregation, select an operator, a property to perform the operation on and the property in the Target Data Source to write the aggregated value to.

Aggregation Operations

Name	Description
Count	Returns the number of objects. It does not require the selection of a property.
Sum	Returns the sum of the values of the selected property.
Average	Returns the average value of the values of the selected property.
Max	Returns the maximum value of the selected property.
Min	Returns the minimum value of the selected property.
Population Standard Deviation	Calculates the population standard deviation of the values of the selected property. Use if the values encompass the entire population of data to be represented. Read more at https://www.mongodb.com/docs/manual/reference/operator/aggregation/stdDevPop/
Sample Standard Deviation	Calculates the sample standard deviation of the values of the selected property. Use if the values encompass a sample of a population of data from which to generalize about the population. Read more at https://www.mongodb.com/docs/manual/reference/operator/aggregation/stdDevSamp/
First	Returns the first value of the selected property.
Last	Returns the last value of the selected property.