Pareto Chart in Tableau
Pareto chart is basically based on the theory of “80-20” phenomena, where it means that 80% of the output is being generated by the 20% of the input. In terms of retail data, we can also say like this that 80% of revenue is from 20% of customers. Pareto chart is a combination of both bar and line graph in which bars are arranged in the descending order and line in the ascending cumulative total. Learn Tableau for Data Science.
Summary:
In this blog, I am going to create a Pareto chart in tableau using Sample-Superstore data.
To create a Pareto chart, we first need to know the dimension and measure. So, in this case, I am taking “Sub-Category” as dimension and “Profit” as a measure.
Following are the steps to create a Pareto chart in Tableau:
- Connect to Sample-Superstore dataset: Open the Tableau Desktop and select the “Sample-Superstore” dataset
- Go to Sheet1:
- Drag the “Sub-Category” dimension to “Columns” shelf and “Profit” measure to rows shelf
- Sort the “Sub-Category” in descending order based on “Profit” values
- Now, again drag the “Profit” measure to “Rows” shelf and put it on the right side after 1st “Profit” field
Also, make the chart as “Entire View”. - Select the “Sum(Profit) (2)” in marks card and change the type of chart to “Line”
- Make a dual axis chart by selection the “Dual Axis” option from a 2nd copy of ‘Sum(Profit)” measure
- Perform the table calculation on the 2nd copy of “Profit” field:
- Click on the “Color” marks card, to change the color of the line and the Pareto chart is completed