Use the Perform Collection Operation action node to perform operations on collections, such as taking the average, median, minimum, or maximum of a number field, or combining a collection's text items into one text value. Additionally, you can filter, sort, and count items or pick a specific item in a collection.
Sum
Returns the sum of items in a numeric field in the collection.
Average
Calculates the arithmetic mean of the value of items in a numeric field in the collection (i.e., the sum of the values divided by the number of values).
Median
Calculates the median of the items of entries in a numeric field in the collection, (i.e., the value for which 50% of values in the field are higher and 50% are lower).
Minimum
Returns the minimum value present in the items of a numeric field in the collection.
Maximum
Returns the maximum value present in the items of a numeric field in the collection.
Count
Counts the number of items in the collection. No collection field needs to be selected.
Combine to text
Adds separation between items in a text field in the collection. It collects all entries in the text field and separates them with Separator. The last entry is separated with a different Final separator. Example: To combine the entries "Jane Doe," "John Doe" and "Susan Smith" into a text variable "Jane Doe, John Doe, or Susan Smith" select a separator ", " and a final separator ", or ".
Sort
Arranges the items in a collection in either ascending or descending order based on the chosen value. The items in the collection can be sorted alphabetically, by number or by date.
Filter
Filter the items in a collection to create another collection with fewer or an equal number of items. The filter conditions can be configured with the Rule Builder. This operation is particularly helpful when combined with other operations.
Example: To determine the number of employees in a collection who are associates, first, filter the list for the position = Associate, then count the number of items in the filtered collection.
Pick
Select a collection and choose an item in the field The nth element. Then, only the item at the nth position of the collection will be created as a new variable.