Aggregation functions



sum( [element sets] )

Simple sum of elements

count( [element sets] )

Number of non-empty elements

allcount( [element sets] )

Number of elements, both empty and non-empty.

stdev( [element sets] )

Standard deviation of elements

avg( [element sets] )

Average of elements

max( [element sets] )

Maximal value found in elements

min( [element sets] )

Minimal value found in elements

rankasc( [element sets] )

Rank elements from lowest value to highest value

rankdesc( [element sets] )

Rank elements from highest value to lowest value

median( [element sets] )

Median of elements

Was this article helpful?
0 out of 0 found this helpful


1 comment
  • Hi Ole,

    In many of your articles I miss the link to where I can apply this information.

    For example where do I apply these aggregation functions.

    Maybe it is due too my lack of courses and experience but with this info i can learn easier and quicker.

    regards dirk-jan


Please sign in to leave a comment.