Select Page

Pareto Principle ( also known as  80% of the effects come from 20% of the causes). To test whether superstore sales follow Pareto’s law we need to check if 80% of the profit come from 20% of the customers.  In Tableau, we can do this visually by creating a Pareto chart.  Let’s see how this looks using global superstore data

Step 4 – Add a table calculation to your measure pill(profit). The table calculation should be configured as per the image below.
•          Calculation type:                Running Total’
•    Summarize values using:        ‘Sum’
•                    Running along:       ‘Customer Name’ (dimension)
•                 Secondary Type:      ‘Percent of Total’
•                   Compute using:       Specific Dimensions ‘Customer Name’ (or your dimension)

Now we have the customer names on the x axis and the running total of the percentage of profit on the y axis. If you hover over the chart the tooltips will show which customer is at which percentage.

Step 7-

Now we need to add a nested table calculation to get the curve back. Click count distinct(Customer name) and add table calculation. The table calculation should be configured as per the image below.

• Calculation type:                 ‘Running Total’
• Summarize values using:    ‘Sum’
• Running along:                 ‘Customer Name’ (or your dimension)
• Secondary Type:                 ‘Percent of Total’
• Compute using:                   Specific Dimensions ‘Customer Name’ (or your dimension)

Now change the mark type to “bar” in the mark shelf

Step 8:

After that drag the measure from rows shelf to colour in the mark shelf

Step 9:

In case you want to make it clearer, you can duplicate the measure pill (customer name) form the columns shelf and drag it to the colour ‘shelf’ and then set colour to diverging colour.

Step 10:

The Pareto chart is now complete. By adding the reference lines you can assist the user in how to read the chart. On the ‘Analytics Pane’ drag a reference line onto both axis. Set the reference line on the x axis to constant 0.2 (20%), and the reference line on the y axis to constant 0.8 (80%) as shown in the below screenshot.

When the two reference lines cross, that means 80% of the profit come from 20% of the customers