Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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:

...

GROUP_SORT_DESC ()

...

Info
titleINFO

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:

Aggregate Functions
Anchor
AggregateFunctions
AggregateFunctions

Aggregate functions combine and then operate on all the values in a group. The function returns one value for each group.

Info
titleINFO

Due to the different nature of group series functions and aggregate functions, they can't be used in the same workbook sheet.

Info
titleINFO

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:

Note

Due to the different nature of group series functions and aggregate functions, they can't be used in the same workbook sheet.

Real World Examples of Group Series Functions

...