1. Home
  2. Knowledge Base
  3. Working with Data
  4. [Desktop] How to use the Rank Block

Next >>

<< Prev

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.

How to use the Rank Block
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:

Documentation

Length:

0:40

You can download a free trial of Analytics Canvas to follow along with the video.

Back to more Support    |   Try Analytics Canvas for Free

Was this article helpful?

Related Tutorials/Video