In Datameer grouping functions are split into two distinct types of functions, group series functions and aggregate functions.
...
Group series functions operate row-wise within a group. The function is applied to every row and therefore returns a value for every argument in the group.
The following functions in Datameer are group series functions:
...
...
| Info | ||
|---|---|---|
| ||
Functions IF, AND, and OR (as well as operators && and ||) arguments are evaluated lazily. This evaluation strategy is used to prevent failures caused by evaluating expressions that may result in an exception. Problems can occur around lazy evaluation when you are working with the functions that maintain state. This is true for all of the group series functions. When using a group series function within an IF()'s 2nd or 3rd argument or the functions AND() / OR() in any argument position, Datameer can't guarantee that all of their arguments will be evaluated. |
The following functions in Datameer are group series functions:
- GROUPACCUMULATE()
- GROUPBOTTOMN()
- GROUPBYBIN()
- GROUPBYCUSTOMBIN()
- GROUPBYGAP()
- GROUPCOMBIN ()
- GROUPPREDICTIVEWINDOWS ()
- GROUPROWNUMBER ()
- GROUPSESSIONS ()
- GROUPTOPN ()
- GROUPUNIQUES ()
- GROUP_DIFF ()
- GROUP_PAIR ()
- GROUP_PATH ()
- GROUP_PATH_CHANGES ()
- GROUP_PREVIOUS ()
- GROUP_SORT_ASC ()
Aggregate Functions
| Anchor | ||||
|---|---|---|---|---|
|
Aggregate functions combine and then operate on all the values in a group. The function returns one value for each group.
| Info | ||
|---|---|---|
| ||
Due to the different nature of group series functions and aggregate functions, they can't be used in the same workbook sheet. |
| Info | ||
|---|---|---|
| ||
Aggregations functions applied to empty groups (all records have been filtered) will result in no entry, e.g. GROUPCOUNT() will not return 0 but no record. |
The following functions in Datameer are aggregate functions:
- GROUPAND ()
- GROUPANOVA()
- GROUPANY ()
- GROUPAVERAGE ()
- GROUPCONCAT ()
- GROUPCONCATDISTINCT ()
- GROUPCOUNT ()
- GROUPCOUNTSDISTINCT ()
- GROUPFIRST ()
- GROUPJSONOBJECTMERGE()
- GROUPLAST ()
- GROUPMAP ()
- GROUPMAX ()
- GROUPMEDIAN ()
- GROUPMIN ()
- GROUPOR()
- GROUPPERCENTILE ()
- GROUPSELECT()
- GROUPSTDEVP ()
- GROUPSTDEVS ()
- GROUPSUM ()
- GROUPTTEST()
- GROUP_HOLT_WINTERS()
- GROUP_JACCARD_DIST ()
- GROUP_MOVING_AVERAGE()
...
Real World Examples of Group Series Functions
...