By the definition: A Pareto chart, is a type of chart that contains both bars and a line graph, where individual values are represented in descending order by bars, and the cumulative total is represented by the line. For what Pareto chart is really popular is its rule “twenty eighty (20,80)" — in the most businesses top 20% of customers give 80% of the revenue. Let’s check is it also true for our famous source :) This way I also want to say thank you for the Pareto Chart suggestion. Sample Superstore data Milos Oroz With connecting to , choosing and , and then sorting descending by SUM(Profit), we should get something like this: Tableau Sample Superstore Profit Product names Duplicate the with holding down CTRL key left click and drag it the side, do the and , right click on the same measure and → → : Sum(Profit) Quick Table Calculation Running Total Edit Table Calculation Add Secondary calculation Percent of Total Now we come to the step where we want to change from Text into a Calculation. Product Name Right click on , select and then . Product Name Measure Count(Distinct) Right click on it again and choose → . Quick Table Calculation Running Total Edit it with adding the → Secondary Calculation Percent of Total. Your Sheet will look something like this (on the ): left side Drag a new field and drop it onto the on the . Right click and it descending by the . Product Name Details All Marks Card Sort Sum of Profit Right click on the measure → Edit → pick the as a . This same thing do also for your first in shelf ! Columns CNTD(Product Names) Table Calculations Product Name Specific DImension Sum(Profit) Rows With putting out negative values of Profit, you will get this view: Right click on axis → . On the card change the to and to the : Profit Dual axis Marks Sum(Profit) Area % of Total Running Sum of Profit Line Hovering the mouse over the existing dots, we can easily see the ratios between two corresponding measures. Our example shows that 20.02% of our top gives us 78.65% of :) Product Names Profit For visual effects you can also add some . Reference lines Found this post useful? Kindly tap the ❤ button below! :) About The Author Leon Agatic is a Tableau Enthusiast. You can connect with him on , , and . Medium Twitter LinkedIn Reddit *Wanna me? Contact me on ! hire LinkedIn … , , Readers also interested in LTM Moving Calculation (Finance KPI) Diverging Bar Chart Modified Pie Charts

Twitter

Too Long; Didn't Read

In your car, at home, or at work — Bosch technology shapes many areas of life.

Tableau: Pareto Chart (20,80) — Top Products, Customers, …

Too Long; Didn't Read

Company Mentioned

Leon Agatić

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

Tableau: Pareto Chart (20,80) — Top Products, Customers, …

Too Long; Didn't Read

Company Mentioned

Leon Agatić

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

RELATED STORIES