Aggregation functions#

count_distinct

Return a measure equal to the distinct count of the passed measure across the specified scope.

long

Return a measure equal to the sum of the positive values of the passed measure across the specified scope.

max

Return a measure equal to the maximum of the passed measure across the specified scope.

max_member

Return a measure equal to the member maximizing the passed measure on the given level.

mean

Return a measure equal to the mean of the passed measure across the specified scope.

median

Return a measure equal to the median of the passed measure across the specified scope.

min

Return a measure equal to the minimum of the passed measure across the specified scope.

min_member

Return a measure equal to the member minimizing the passed measure on the given level.

prod

Return a measure equal to the product of the passed measure across the specified scope.

quantile

Return a measure equal to the requested quantile of the passed operand across the specified scope.

short

Return a measure equal to the sum of the negative values of the passed measure across the specified scope.

single_value

Return a measure equal to the value aggregation of the operand across the specified scope.

square_sum

Return a measure equal to the sum of the square of the passed measure across the specified scope.

std

Return a measure equal to the standard deviation of the passed operand across the specified scope.

sum

Return a measure equal to the sum of the passed measure across the specified scope.

sum_product

Return a measure equal to the sum product aggregation of the passed factors across the specified scope.

var

Return a measure equal to the variance of the passed operand across the specified scope.