Aggregation functions#

count_distinct

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

distinct

Return an array measure equal to the distinct values 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.