How to use the rank function in Tableau

This recipe helps you use the rank function in Tableau

Recipe Objective - How to use the Rank function in Tableau?

Step 1:-

Create any dummy data set with one-two column one is the dimension, and another is measure having 7-8 rows.

Step 2:-

Connect the dataset.

Step 3:-

Drop the dimension onto the "row shelf".

Learn About the Application of ARCH and GARCH models in Real-World

Step 4:-

Drop the measure onto the "detail" in the "marks" card.

Step 5:-

Create a "calculation field" and type “Rank(Sum([Your Measure]))”. Set the name of the field.

Step 6:-

Drag this file and drop it on the "row shelf" and click on the drop-down and select "discrete".

And Now the rank of each row will show up in the different column

Different types of Rank Functions.

1. Rank() - This function sets the rank, but it will skip the highest rank whenever we have the same value.

2. Rank_Dense() - This Function will assign an identical rank to the identical value. This function will not skip any value.

3. Rank_Unique() - This function will not assign an identical rank to the identical value.

What Users are saying..

profile image

Gautam Vermani

Data Consultant at Confidential
linkedin profile url

Having worked in the field of Data Science, I wanted to explore how I can implement projects in other domains, So I thought of connecting with ProjectPro. A project that helped me absorb this topic... Read More

Relevant Projects

Time Series Project to Build a Multiple Linear Regression Model
Learn to build a Multiple linear regression model in Python on Time Series Data

Build Deep Autoencoders Model for Anomaly Detection in Python
In this deep learning project , you will build and deploy a deep autoencoders model using Flask.

Deploy Transformer-BART Model on Paperspace Cloud
In this MLOps Project you will learn how to deploy a Tranaformer BART Model for Abstractive Text Summarization on Paperspace Private Cloud

Demand prediction of driver availability using multistep time series analysis
In this supervised learning machine learning project, you will predict the availability of a driver in a specific area by using multi step time series analysis.

Hands-On Approach to Master PyTorch Tensors with Examples
In this deep learning project, you will learn how to perform various operations on the building block of PyTorch : Tensors.

Machine Learning project for Retail Price Optimization
In this machine learning pricing project, we implement a retail price optimization algorithm using regression trees. This is one of the first steps to building a dynamic pricing model.

Build a Graph Based Recommendation System in Python-Part 2
In this Graph Based Recommender System Project, you will build a recommender system project for eCommerce platforms and learn to use FAISS for efficient similarity search.

NLP Project for Beginners on Text Processing and Classification
This Project Explains the Basic Text Preprocessing and How to Build a Classification Model in Python

Create Your First Chatbot with RASA NLU Model and Python
Learn the basic aspects of chatbot development and open source conversational AI RASA to create a simple AI powered chatbot on your own.

Deep Learning Project for Beginners with Source Code Part 1
Learn to implement deep neural networks in Python .