The Rank Block offers four different strategies for ranking data, as described below, and offers the analyst the ability to rank based on more than one dimension.
Step 1. Drag and drop the Rank Block from the Block Library onto the Main Canvas.
Step 2. Connect input data.
Step 3. Configure settings: select Value Column, Rank Method, and a column to rank by.
Step 4. Use Data Viewer to view the results.
ROW NUMBER – Returns the sequential number of a row within a partition of a result set, starting at 1 for the first row in each partition.
RANK – Returns the rank of each row within the partition of a result set. The rank of a row is 1, plus the number of ranks that come before the row in question.
DENSE RANK – Returns the rank of rows within the partition of a result set, without any gaps in the ranking. The rank of a row is 1, plus the number of distinct ranks that come before the row in question.
NTILE – Distributes the rows in an ordered partition into a specified number of groups. The groups are numbered, starting at 1. For each row, NTILE returns the number of the group to which the row belongs.
- Block settings
- Rank Types
Transcript – How to use the Rank Block
You can download a free trial of Analytics Canvas to follow along with the video.