How do I build a Pareto chart in Tableau?

What is a Pareto chart, though?

A Pareto chart is simply an illustration of the well-known Pareto principle, stating that roughly 80% of the effects are driven by 20% of the causes.

Applied to business, this often translates in companies achieving 80% of their revenue with 20% of their customers.

Economics is not much different. The charts below examine the structure of Dutch services. The first chart shows the value of imports, whereas the second illustrates the revenues gained from service exports.

https://public.tableau.com/profile/angelina.teneva#!/vizhome/ParettoChart/Pareto

How do I build such a chart then?

Chart Type 1:

  1. Add your measure twice on Rows

2. Change the “Mark” type of the second measure to “Line”

3. Add the following “Running Total” calculation to your second measure

4. Add your measures on a dual axis

5. Adjust the colours and fit to “Entire view”

6. Add 80% reference line

Chart Type 2:

  1. Add a Running Total calculation as the one below to your selected measure

2. Add “count distinct” measure to your “Service” dimension to get the horizontal axis percentage

3. Add the same “Running Total” calculation you’ve used before to your “count distinct” measure

4. Fit to “Entire View”

5. Add 80% and 20% reference lines

6. Sort your chart in descending order of the used measure

7. Add your chosen measure to the Rows area again and change its mark to “Bars”

8. Place your second measure on dual axis and move the marks to back

9. Place “Service” (or your dimension measure) on “Path” to ensure a continuous % line

10. Adjust the colours and you’re done 🙂

Happy vizzing!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.