Questions about this article, topic, or product? Click here. 

Log Only Functions

The following functions require the use of the 'Aggregate' or 'AggregateAll' prefixes in the fol-lowing format.

  • [Aggregate.Group.Property]
  • [AggregateAll.Group.Property]

'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.

  • joinDistinct([AggregateAll.DepthRelatedExploratoryInformation.PitLength], '', ' ')
  • joinDistinct([Aggregate.DepthRelatedExploratoryInformation.PitLength], 'F2', '+')+'m'
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, delim-iter)
joinDistinct Concatenates unique values and separates them with a delimiter. A format can specified to present numeric values in a desired format. joinDistinct(val-ues, 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)
Recommended
Related
Communities
Support and Services
Training and Learning
Social Media