You are viewing an old version of this page. View the current version.
Compare with Current
View Page History
« Previous
Version 24
Next »
Category: General
Available from version: 1.0.104
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.
| 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. |
| Group by* | 1.0.104 | Variables are grouped based on their values. | Variable array | | Editable field | |
Parameter*- required field
Grouping by indeksy column:
Grouping by indeksy and login columns:
Group by indeksy variable
Sample set of data:
| nazwisko | Całkowity | Zmiennoprzecinkowa_tab | indeksy | login |
|---|
| Kowalski | 4 | 4.5 | 1 | foo |
| Nowak | 7 | 5.5 | 1 | bar |
| Wiśniewski | 2 | 2.1 | 4 | bar |
| Kowalczyk | 5 | 1.1 | 1 | foo |
Grouping result:
{"variableType":{"nazwisko"="string", "Całkowity"="integer", "Zmiennoprzecinkowa_tab"="double", "indeksy"="integer"},
"data":[
{"nazwisko":"Kowalski;Nowak;Kowalczyk","Całkowity":16,"Zmiennoprzecinkowa_tab":1.1,"indeksy":1},
{"nazwisko": "Wiśniewski","Całkowity":2,"Zmiennoprzecinkowa_tab":2.1,"indeksy":4}]
}
Group by indeksy oraz login variables
Sample set of data:
| nazwisko | Całkowity | Zmiennoprzecinkowa_tab | indeksy | login |
|---|
| Kowalski | 4 | 4.5 | 1 | foo |
| Nowak | 7 | 5.5 | 1 | bar |
| Wiśniewski | 2 | 2.1 | 4 | bar |
| Kowalczyk | 5 | 1.1 | 1 | foo |
Grouping result:
{
"variableType":{"nazwisko"="string", "Całkowity"="integer", "Zmiennoprzecinkowa_tab"="double"},
"data":[{"nazwisko":"Kowalski;Kowalczyk","Całkowity":9,"Zmiennoprzecinkowa_tab":1.1},
{"nazwisko": "Nowak","Całkowity":7,"Zmiennoprzecinkowa_tab":5.5},
{"nazwisko": "Wiśniewski","Całkowity":2,"Zmiennoprzecinkowa_tab":2.1}]
}
