Aggregation functions

Function

Description

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

Comments

0 comments

Please sign in to leave a comment.