Function to group data based on given grouping values. It is possible to call specific aggregating functions on grouped data. The resulting data is returned as TableStore object.
Configuration parameters
Parameter name
From version
Description
Parameter type
Default value
Field type
Comments and restrictions
Agregate function
1.0.x
The set of functions that can be called on the given variable.
Text array
Drop-down list
Available functions:
AVG- returns the average of grouped values. The function can be used for the following types of array variables: integer, float, amount.
CONCAT- is used to concatenate character strings of grouped values. The function can be used for a string array variable.
COUNT- returns the number of rows in a given group as an integer. The function can be used for all types of array variables.
MAX- returns the highest value of grouped values. The function can be used for the following types of array variables: integer, float, amount, date.
MIN- returns the lowest value of grouped values. The function can be used for the following types of array variables: integer, float, amount, date.
SUM- allows you to sum grouped values. The function can be used for the following types of array variables: integer, float, amount. The result is rounded to 4 decimal places.
In order to pass the value of the grouping variable (s) to the TableStore object, the value of the aggregate function must be empty.
Variable*
1.0.x
Variables whose values are to be aggregated after grouping.
Variable array
Editable field
Concat separator
1.0.x
Separator with which the values after grouping will be joined.
Text
Editable field
Shows when CONCAT is selected from the Aggregate Function parameter. If several CONCAT Functions are added, the separator is common to them.
Number of decimal palces*
1.0.x
Number of decimal places in result value.
Text
Editable field
Shows when AVG is selected from the Aggregate Function parameter.A value from 0 to 8 is allowed.
