Rank
This step allows to compute a rank column based on a value column that can be sorted in ascending or descending order. The ranking can be computed by group.
There are 2 ranking methods available, that you will understand easily through those examples:
standard
: input = [10, 20, 20, 20, 25, 25, 30] => ranking = [1, 2, 2, 2, 5, 5, 6]dense
: input = [10, 20, 20, 20, 25, 25, 30] => ranking = [1, 2, 2, 2, 3, 3, 4]
(The dense
method is basically the same as the standard
method, but rank
always increases by 1 at most).
This step is supported by the following backends:
 Mongo 4.2
 Mongo 4.0
 Mongo 3.6
Where to find this step?
 Widget
Compute
 Search bar
Options reference

Value column to rank
: the value column that will be ordered to determine rank 
Sort order
: how to order the value column to determine ranking. Either asc(ending) or desc(ending), ‘desc’ by default 
Ranking method
: either ‘standard’ or ‘dense’, as explained above 
(Optional) Group ranking by
: optional, if you need to apply the ranking computation by group of rows, you may specify here the columns to be used to constitute groups (see example 2 below) 
(Optional) New column name
: Optional, if you want to give a custom name to the output column to be created (by default it will be your original column name suffixed by ‘\RANK’).
Example 1 : Basic configuration
This configuration results in:
Example 2 : Configuration with optional parameters
This configuration results in:
 Previous
 Next