The following functions require the use of the 'Aggregate' or 'AggregateAll' prefixes in the following format.
'Aggregate' performs an aggregation of the values for a single instance whereas 'AggregateAll' joins instances to their parent group(s). An example of their use follows.
Function |
Description |
Example |
---|---|---|
average |
Calculates the average of the values. |
average(values) |
count |
Counts the number of entries. |
count(values) |
join |
Concatenates all values and separates them with a delimiter. A format can specified to present numeric values in a desired format. |
join(values, format, delimiter) |
joinDistinct |
Concatenates unique values and separates them with a delimiter. A format can specified to present numeric values in a desired format. |
joinDistinct(values, format, delimiter) |
max |
Determines the maximum value from a list of values. |
max(values) |
min |
Determines the minimum value from a list of values. |
min(values) |
orderAsc |
Orders a list such that the elements are in an ascending order. |
orderAsc(values) |
orderDsc |
Orders a list such that the elements are in a descending order. |
orderDsc(values) |
sum |
Returns the sum of all values. |
sum(values) |
first |
Determines the first value from a list of values. |
first(values) |
last |
Determines the last value from a list of values. |
last(values) |