Rank calculations in Tableau - Step-by-Step Guide

Introduction

Rank calculations help you order your data by value, like showing top salespeople or best-selling products. This makes it easy to see who or what is performing best in your data.

When you want to show the top 5 products by sales on a dashboard.

When you need to rank employees by their monthly performance.

When comparing regions to see which has the highest revenue.

When creating a leaderboard for customer satisfaction scores.

When filtering data to show only the top-ranked items.

Steps

Step 1: Open your Tableau workbook

- Tableau Desktop main window

Your data and worksheets are visible

Step 2: Click

- Analysis menu > Create Calculated Field

A dialog box opens to create a new calculation

Step 3: Type

- Calculated Field dialog box

You enter the rank formula

💡 Use the formula RANK(SUM([Sales])) to rank by total sales

Step 4: Name

- Calculated Field dialog box

The calculation is saved with a clear name like 'Sales Rank'

Step 5: Drag

- New calculated field 'Sales Rank' to Rows or Columns shelf

The view updates to show rank numbers alongside your data

Step 6: Sort

- Right-click on the dimension or measure in the view > Sort

Data is ordered by rank ascending or descending

Before vs After

Before

A table shows product names with sales amounts but no order

After

The table shows product names with sales amounts and a rank number from 1 to N based on sales

Settings Reference

Compute Using

📍 Right-click calculated field in view > Edit Table Calculation

Defines how Tableau calculates rank across rows or columns

Default: Table (Across)

Rank Function Type

📍 Calculated Field formula

Determines how ties are handled in ranking

Default: RANK

Common Mistakes

Using RANK without setting 'Compute Using' correctly

The rank numbers do not reflect the intended dimension or level of detail

Edit the table calculation and set 'Compute Using' to the correct dimension, like 'Product Name'

Ranking a measure without aggregation

The rank calculation fails or shows unexpected results

Always use an aggregation like SUM or AVG inside the RANK function, e.g., RANK(SUM([Sales]))

Summary

Rank calculations order your data by value to highlight top or bottom performers.

You create rank calculations by making a calculated field with RANK and an aggregation.

Remember to set 'Compute Using' properly to get correct ranking results.