Pareto chart in Tableau
A Pareto Chart is a dual-axis combination chart. It is a chart in Tableau used to highlight dimension members that are having the biggest impact on the measure in question. It is named after Vilfredo Pareto.
So, let me take you through the steps to build a Pareto Chart in Tableau.
Let’s begin.
- What is a Pareto Chart?
- Left join the Returns table to the Orders table
- Create a calculated field to count the number of returns
- Building the Pareto Chart
What is a Pareto Chart?
A Pareto chart is a dual-axis combination chart in Tableau. On its primary axis, bars are used to show the basic raw quantities for each dimension, usually sorted in descending order, and on the secondary axis, a line graph is used to show the cumulative total in a percentage format. Now, while this chart type serves a variety of purposes, it is most known for being a part of the seven basic tools of quality control. So, it is traditionally used to identify the biggest opportunities for improvement.
I’m going to be sticking with a quality control scenario. This article will use the Sample Superstore which is already available on the Tableau Desktop. We shall use this data set to look at which product sub-categories contribute the most returned items. The final chart will look like the following image;
First of all, this tutorial requires taking two additional steps to prepare the data.
1. Left join the Returns table to the Orders table
In this step, you need to right-click on the Sample Superstore data connection and choose Edit data source. A new interface will appear.
Now you can drag the Returns table next to the Orders table and set up a left join on Order ID.
2. Create a calculated field to count the number of returns
The formula to use for this calculation is the following;
COUNT([Returns] = “Yes”)
Now, we are all set to build out the Pareto Chart.
3. Building the Pareto Chart
- First, you must create a bar chart that looks at the number of returns per Product Sub-Category and sort it in descending order. You shall have the following result on your screen.
- Secondly, go ahead and create a dual-axis combination chart by dragging the Returns measure from the Measure Shelf to the right axis. Change the mark type on the primary axis back to the bar and the secondary axis to the line. At this point, the viz will look something like the following;
- Now the step that makes a Pareto Chart a Pareto Chart. Adding a table calculation and a secondary table calculation to this Returns pill. This shall display the cumulative percent of returns across product sub-categories.
- To add the first table calculation, click on the second Returns pill, hover over Quick table calculation, and choose Running total. With the table calculation for the running total, you can add a second table calculation on the result. This is how we can calculate the raw running total number at each product sub-category, then add a second calculation to determine the cumulative percent of the total.
- For the addition of a secondary table calculation, click the second Returns pill again, select the option Edit table calculation and check the box at the bottom of the interface named Add Secondary Calculation. Change the Secondary Calculation Type to Percent of Total. This will display the cumulative percent of the total.
After changing the axis tick marks for a cleaner look, you will be left with the following viz;
This Pareto Chart in Tableau can now be used for drawing insights such as, “The business’ three most returned product sub-categories are causing about 40% of the total returns.” Pareto Charts are usually an effective way to quickly highlight the potential for improvement and give enterprises a scale for how urgently a quality control problem should be treated.
Hope you enjoyed this article. Cheers!
I hope you all, now, have a fair idea about Data Blending in Tableau from this blog. If you wish to check out more articles on the market’s most trending technologies like Artificial Intelligence, DevOps, Ethical Hacking, then you can refer to Edureka’s official site.
Do look out for other articles and videos in the series which will help you understand various concepts of Tableau.
7.Step By Step Guide To Learn Tableau Public
8. Tableau Desktop vs Tableau Public vs Tableau Reader
9. How to Create and Use Parameters in Tableau?
10. Tableau Charts
11. Data-blending
13.Top 50 Tableau Interview Questions You Must Prepare In 2020
Originally published at https://www.edureka.co on September 19, 2019.