Perform Collection Operation Action – BRYTER | Help Center

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.

You can also perform these operations using transform options when referencing collection fields in places such as the calculator field of Calculate actions and Number values, or the default value field of an input node.

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 ".

Note that you often need to add spaces after the separators to get your desired result.

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.

Related to

Sum