Member Summaries
This list contains predefined functions that return either a single summary value for a set of members or a different summary value for each member of a set of members.
- aggregate
Returns a calculated value using the appropriate aggregation function based on the aggregation type of the expression. - average
Returns the average value of the selected data items. - count
Returns the number of selected data items excluding null values. - maximum
Returns the maximum value of selected data items. - median
Returns the median value of selected data items. - minimum
Returns the minimum value of selected data items. - percentage
Returns the percent of the total value for the selected data items. - percentile
Returns a value, on a scale from 0 to 100, that indicates the percent of a distribution that is equal to or below the selected data items. - quantile
Returns the rank of a value for the specified range. It returns integers to represent any range of ranks, such as 1 (highest) to 100 (lowest). - quartile
Returns the rank of a value, represented as integers from 1 (highest) to 4 (lowest), relative to a group of values. - rank
Returns the rank value of the selected data items. The type of ranking returned (Olympic, dense, or serial) is data source dependent. The sort order is optional; DESC is assumed by default. - standard-deviation
Returns the standard deviation of the selected data items. - standard-deviation-pop
Returns the standard deviation population of the selected data items. - total
Returns the total value of the selected data items. - variance
Returns the variance of the selected data items. - variance-pop
Returns the variance population of the selected data items.
Parent topic: Using the expression editor