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.
To rank data:
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.
Rank Types
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.
Contents:
- Block settings
- Rank Types
Related Materials:
Transcript – How to use the Rank Block
Other resources:
Length:
0:40
You can download a free trial of Analytics Canvas to follow along with the video.