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.
How do I build such a chart then?
Chart Type 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:
- 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 🙂