Description
Returns the rank of a number in a list or metric. The rank of a number is its size relative to other values.
Syntax
RANK(number[,group][,direction][,ties])
 group (optional): dimension on which ranking will be reset for each item
 direction (optional):
ASC
for ascending,DESC
for descending  ties (optional):
MINIMUM
(by default),MAXIMUM
,SEQUENTIAL
,AVERAGE
If you need to skip one parameter in the function, such as group
for instance, you can use a constant such as 0
, false
or ""
instead.
Return type
integer
(compatible with number)
Examples
Case 
Results 
Return Type 

returns the rank of each cell in the metric called 


returns, for each month (reset to 1 when switching month), the rank of each cell in the metric called 

RANK('Quantity Sold', 0, desc, sequential) 
returns the rank of each cell in the metric called 

Excel equivalent: RANK(number,ref,[order])
Comments
0 comments
Please sign in to leave a comment.