EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login
Home Data Science Data Science Tutorials Tableau Tutorial Rank Function in Tableau
Secondary Sidebar
Tableau Tutorial
  • Functions
    • Tableau Functions
    • Tableau String Functions
    • Concatenate in Tableau
    • Rank Function in Tableau
    • Tableau Aggregate Functions
    • Window Sum Tableau
    • LOD Expressions in Tableau
    • LOOKUP Function in Tableau
    • Tableau Fixed Function
    • Tableau Count Distinct
    • Tableau Window Functions
  • Basic
    • What is Tableau
    • What is Tableau Dashboard
    • What is Tableau Server
    • Uses of Tableau
    • Tableau Versions
    • Tableau Architecture
    • Is Tableau Free
    • Tableau New Features
    • How To Install Tableau
    • How to Use Tableau?
    • Install Tableau Server
    • Tableau Commands
  • Charts
    • Tableau Charts
    • Tableau Bar Chart
    • Tableau Chart Types
    • Donut Chart in Tableau
    • Tableau Gauge Chart
    • Funnel Chart in Tableau
    • Gantt Chart in Tableau
    • Bubble Chart in Tableau
    • Pareto Chart in Tableau
    • Sankey Chart In Tableau
    • Stacked Bar Chart in Tableau
    • Tableau Bullet Chart
    • Waterfall Chart in Tableau
    • Line Chart in Tableau
    • Heat Map in Tableau
    • Histogram in Tableau
    • CrossTab in Tableau
    • Treemap in Tableau
    • Trend Lines in Tableau
    • Tableau Reference Lines
    • Tableau Dual Axis
    • Legend in Tableau
    • Pie Chart in Tableau
    • Tableau Storyline
  • Statement
    • Tableau IF Statement
    • Case Statement in Tableau
  • Sort/Filters
    • Sorting in Tableau
    • Filters in Tableau
    • Types of Filters in Tableau
    • Tableau Action Filter
    • Context Filter in Tableau
    • Tableau Parameter Filter
    • Adding Filters in Tableau Dashboard
    • Tableau Context Filter
  • Tableau Dashboard
    • Dashboard in Tableau
    • Tableau Dashboard Examples
    • Tableau Dashboard Creation
    • Tableau Dashboard Design
    • Tableau Workbook
  • Advanced
    • Tableau Bins
    • Tableau 3D
    • Tableau Export to Excel
    • Tableau Reporting
    • Tableau Reader
    • Tableau Map
    • Tableau Viewer
    • Tableau Prep Builder
    • Tableau Bridge
    • Tableau Tooltip
    • Tableau Hyper
    • Tableau Zen Master
    • Tableau Union
    • Tableau Templates
    • Tableau Alerts
    • Tableau Reporting Tool
    • Conditional Formatting in Tableau
    • Tableau Web Data Connector
    • Tableau BI Tool
    • Data Blending in Tableau
    • Parameters in Tableau
    • Tableau Data Sets
    • Creating Set in Tableau
    • Tableau Drill Down
    • Tableau Dynamic Parameters
    • Tableau Table Calculation
    • Tableau Visualization
    • Tableau Joins
    • Pivot in Tableau
    • Data Visualization With Tableau
    • Forecast in Tableau
    • Map Layers in Tableau
    • Group in Tableau
    • Tableau Group by
    • Hierarchy in Tableau
    • Sets in Tableau
    • How to create a Set in Tableau
    • Tableau Order of Operations
    • Tableau User Group
    • Tableau Calculated Field
    • Custom SQL in Tableau
  • Interview Questions
    • Tableau Interview Questions

Related Courses

Tableau Certification Course

Business Intelligence Courses

Data Visualization Courses

Rank Function in Tableau

By Priya PedamkarPriya Pedamkar

Rank Function in Tableau

Introduction to Rank Function in Tableau

Ahead of learning functions in Tableau and their use cases let us first learn what is tableau and why people use it? Tableau is a data visualization tool that can help produce interactive dashboards that helps in a better understanding of the data. Now, let us dive into the functions in Tableau. There are many inbuilt functions in Tableau which are categorized into string functions, table functions and etc. In this article, we are going to discuss the Rank function which is a part of Table functions in tableau. Rank function as the name suggests is used to give the rank to any measure (number related) present in the data set.

How to Use Rank Function in Tableau?

Now, let’s go step by step and see how to use rank function in tableau.

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

1. Open Tableau and we will be able to see the below screen. Connect to a file or server (based on where you input data is present) using the connect option present on the left side of the Tableau landing page.

Landing page

2. For this article, we are going to use the “Sample- Superstore” data store present and the below screenshot will tell us how the data looks like.

All in One Data Science Bundle(360+ Courses, 50+ projects)
Python TutorialMachine LearningAWSArtificial Intelligence
TableauR ProgrammingPowerBIDeep Learning
Price
View Courses
360+ Online Courses | 50+ projects | 1500+ Hours | Verifiable Certificates | Lifetime Access
4.7 (86,112 ratings)

Sample- Super store

3. Click on the option “Sheet 1” present on the bottom left corner and we will be able to see a window like shown below and this is where we prepare our dashboards.

Sheet-1

4. Choose the measure on which we want to apply rank function, here I am going to apply a rank function on Sales measure by taking Region present in dimension as rows. Drag Region dimension to row and drag Sales measure into the marks card and the window will look like the way shown below.

rank function in tableau-1.14

5. To give rank to the sales measure, we have to create a new calculated field first and we do it by giving a right-click on the sales in measures pane. And we can see a new menu appeared like the screenshot here. Now we have to go to create and then click on the calculated field option present here.

rank function in tableau-1.5

6. After clicking on the calculated field, one new window will pop up and in there we can see that “All” is selected in the drop-down present to the right.

rank function in tableau-1.6

7. As mentioned earlier, rank functions will be in table calculations so we have to open the drop-down and select “Table Calculations” and we will be able to see all the rank functions and little information about the functions as shown below.

rank function in tableau-1.7

8. As we want the rank function to be applied on the aggregate of sales measure, the calculation will be “Rank(Sum([Sales]))” and we can give the name to this calculation. Here in this example, I am going to name the calculation as Rank.

rank function in tableau-1.8

9. After giving the calculation, we will go ahead and click on Apply and Ok for this calculation to reflect in the Measures section. After we see Rank in the Measures pane we should drag it onto the aggregate of sales present in the dashboard area, and the dashboard will look like the way shown below

rank function in tableau-1.9

10. Here, in the marks pane both aggregate of sales is set to “details”, to have a better understanding let us change it to “Text” to do this we just have to click on the symbol on the right of measure in marks card and it will open a window with “Text” as one of the options, select it and then the dashboard will look like the way shown below.

aggregate of sales

11. So, after this is done from the values provided we can see that the highest rank (1) is given to the region with the highest value of sales ($725,458). If we want to rank to be shown in a separate column, then change the order of steps by doing Step-10 first and then move on to Step-9.

12. If we want to do any changes in the formatting, we have to click on the drop-down present to the left on the Rank section in Measure values pane and here we can do all the changes in format (Axis and Pane formats) and the window will look similar to the one shown below.

rank function in tableau-1.11

13. Here we are having all different values and If there is the same value who will be given the better rank? Different users have different requirements to solve this tableau provides us with a few more additional features Rank Dense, Rank Unique and Rank Modified. And also tableau by default picks some properties and one of them is sorting in Descending order.

14. So, let us see how these things help us by meeting our requirements.

rank function in tableau-1.13

Importance of Rank Function in Tableau

From the above calculations and types, we can see that when Rank Function is applied it returns the standard competition rank for the current row in the partition. This will be very helpful when we are using the chart to tell the details about which category or region the sales are at best. With these insights, the user or business executives will get to know where they have to improve their business.

Recommended Articles

This is a guide to Rank Function in Tableau. Here we discuss how to use rank function in tableau along with its Importance. You may also look at the following articles to learn more-

  1. Tableau Reference Lines
  2. Tableau Dashboard Design
  3. Tableau Table Calculation
  4. Tableau Chart Types
  5. Tableau Aggregate Functions
  6. Pivot in Tableau
  7. Tableau Context Filter
  8. Introduction to Features and Attributes of Tableau
Popular Course in this category
Tableau Training (8 Courses, 8+ Projects)
  8 Online Courses |  8 Hands-on Projects |  55+ Hours |  Verifiable Certificate of Completion
4.5
Price

View Course

Related Courses

Business Intelligence Training (12 Courses, 6+ Projects)4.9
Data Visualization Training (15 Courses, 5+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Data Science Course

SPSS, Data visualization with Python, Matplotlib Library, Seaborn Package

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more