How to create Pareto Chart in Tableau

Last updated on Oct 25 2021
Anand Vishwanathan

Table of Contents

How to create Pareto Chart in Tableau

A Pareto chart consists of two graphs, such as bar graph and line graph. The same measure is used to create the graph, but the measure values are handled differently.
In Tableau, the purpose of using the Pareto Chart is to identify the contribution of members present in a field.
For example, the data source such as Sample-Superstore, the measure Profit contributed by different dimension, i.e., Sub-Category of products which can be analyzed using the Pareto Chart.
It shows the top members and their contribution. Here is the procedure to create a Pareto Chart as given below.
Step 1: Go to the worksheet.
1) Drag the dimension Sub-Category into the columns shelf.
2) Drag the measure Profit into the rows shelf.

Page 1 Image 1 26
Sub-Category

 

Step 2: Right-click on the Sub-Category field.
Step 3: And select the “Sort” option from the list.

Page 2 Image 2 21
Sort

Step 4: It opens the sort window.
1) Click on the Descending option in sort order.
2) Select the Field Name option under sort section.
3) And select the Field Name as Profit and choose Sum as the aggregation function.

Page 3 Image 3 7
Sum

Step 5: Again, drag measure Profit into the rows shelf. Then,
1) Right-click on the newly added Profit field.
2) And select the Dual Axis option from the list.

Page 4 Image 4 5
Dual Axis

It merges the X-axes of both measures and converts the visualization shown in the below screenshot.

Page 4 Image 5 3
Merges

Step 6: Go to the Marks pane. And
1) Select the SUM(Profit) form the marks pane.
2) Click on the drop-down button.
3) And select the Bar chart from the list, as shown in the following screenshot.

Page 5 Image 6 3
Bar chart

Step 7: Again,
1) Select the Sum(profit)(2) from the marks pane list.
2) Click on the drop-down button.
3) And select the line chart option from the list shown in the below screenshot.

Page 6 Image 7 1
line chart

Step 8: Select the SUM(profit) on the right side of the rows shelf.
1) Right-click on the SUM(profit) field.
2) And select the Add Table Calculation from the list as shown in the below screenshot.

Page 7 Image 8 1
Add Table Calculation

Step 9: It creates the “Table Calculation” window.
1) Select the Running Total option as “Calculation Type“.
2) Choose Sum as the aggregation function.
3) Select Table(across) option as the “Compute Using“.
4) Then click on the Add Secondary Calculation checkbox.
5) It expands further window as Secondary Calculation Type.
6) Select the Percent of Total option from the list.
7) Again select the Table(across) option as the “compute using“.
8) Click on the Closing icon.

Page 8 Image 9
Table Calculation

Step 10: Go to the Marks pane. And
1) Go to the SUM(profit)(2).
2) Click on the color icon in the marks pane.
3) Choose a color from the color options.

Page 9 Image 10
color

After choosing a color, you can see this color line in the graph, and this is the procedure to create a Pareto chart shown in the below screenshot.

Page 10 Image 11
Pareto chart

So, this brings us to the end of blog. This Tecklearn ‘How to create Pareto Chart in Tableau’ blog helps you with commonly asked questions if you are looking out for a job in Tableau Desktop. If you wish to learn Tableau Desktop and build a career in Business Intelligence domain, then check out our interactive, Tableau Desktop Training, that comes with 24*7 support to guide you throughout your learning period. Please find the link for course details:

Tableau Desktop

Tableau Desktop Training

About the Course

Tecklearn’s Tableau Desktop Training teach you how to transform raw data into interactive and shareable dashboards using Tableau. Our Tableau Course covers the necessary analytical skills to Advanced data visualizations by incorporating real-world use-case scenarios, labs, and exercises. Some of the topics included are Data Blending, Data Mapping, Graphs, creation of charts, and LOD expression by using different versions of Tableau, such as Tableau Desktop, Tableau Reader, and Tableau Public.

Why Should you take Tableau Desktop Training?

• The average salary of a Tableau Professional ranges between $108,697 to $158,000 per annum -Indeed.com.
• Tableau has been positioned as a Leader in the Gartner Magic Quadrant for Analytics and Business Intelligence Platforms – Gartner.com.
• Fidelity Investments, Capgemini, EY, Deloitte, EY, JP Morgan, Verizon, Facebook, Dell, General Motors, KPMG, Bank of America and 40,000 other MNCs worldwide across industries use Tableau.

What you will Learn in this Course?

Understanding Tableau

• Why Tableau
• Tableau Product Platforms
• Tableau Architecture
• Tableau Interface

Data Connection with Tableau Desktop

• Features of Tableau Desktop
• Connect to data from File and Database
• Types of Connections
• Data Blending
• Joins and Unions
• Tableau Desktop User Interface
• Basic project: Create a workbook and publish it on Tableau Online

Basic Visual Analytics

• Visual Analytics
• Basic Charts: Bar Chart, Line Chart, and Pie Chart
• Hierarchies
• Data Granularity
• Highlighting
• Sorting
• Filtering
• Grouping
• Sets

Advanced Visual Analytics

• Parameters
• Tool tips
• Trend lines
• Reference lines
• Forecasting
• Clustering

Calculations in Tableau

• Calculated Fields
• Numeric, String, Data, Logical, Addressing and Partitioning
• Table Calculations

Level of Detail (LOD’s) Calculations

Advanced Charts in Tableau

• Box and Whisker’s Plot
• Bullet Chart
• Bar in Bar Chart
• Gantt Chart
• Waterfall Chart
• Pareto Chart
• Control Chart
• Funnel Chart
• Bump Chart

Parameters

• What If Scenarios
• Parameter in CF (KPI control)
• Parameter in Filter (Top N)
• Parameter in reference line

Dashboards and Stories

• Introduction to Dashboards
• The Dashboard Interface
• Dashboard Objects
• Building a Dashboard
• Dashboard Layouts and Formatting
• Interactive Dashboards with actions
• Designing Dashboards for devices
• Story Points

Data Security in Tableau

Optimizations tips and tricks

Interacting with Tableau Server

Working with Tableau JavaScript API

Got a question for us? Please mention it in the comments section and we will get back to you.

0 responses on "How to create Pareto Chart in Tableau"

Leave a Message

Your email address will not be published. Required fields are marked *