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.104
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. The function can be used for the following types of array variables: integer, float, amount, string.
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.
Grouping value- allows to include the values of grouping variables in the result.
Variable*
1.0.104
Variables whose values are to be aggregated after grouping.
Variable array
Editable field
Concat separator
1.0.104
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.104
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.
