Skip to end of metadata
Go to start of metadata

From version 1.0.109 replaced with a function TableStore.groupBy(), more info [FUNKCJE] TableStore

Basic information

Category: General

Available from version: 1.0.104

Description

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 nameFrom versionDescriptionParameter typeDefault valueField typeComments and restrictions
Agregate function1.0.104The 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.104Variables whose values are to be aggregated after grouping.Variable array Editable field 
Concat separator1.0.104Separator 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.104Number of decimal places in result value.Text Editable fieldShows when AVG is selected from the Aggregate Function parameter.A value from 0 to 8 is allowed.
Group by*1.0.104Variables are grouped based on their values.Variable array Editable field 

Parameter*- required field

Sample configuration

Grouping by indeksy column:


Grouping by indeksy and login columns:


Usage example
 Group by indeksy variable
Example

Sample set of data:

nazwiskoCałkowityZmiennoprzecinkowa_tabindeksylogin
 Kowalski4 4.5  1foo
 Nowak7 5.5 1bar
 Wiśniewski22.1 4bar
 Kowalczyk51.1 1foo

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
Example

Sample set of data:

nazwisko  Całkowity Zmiennoprzecinkowa_tab indeksy login
 Kowalski4  4.51  foo
 Nowak7   5.51 bar
 Wiśniewski2 2.14 bar
 Kowalczyk 5 1.11 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}]

}

 

 

Change log

 1.0.104

  • Adding component
 

 

  • No labels