- Bernard

# Tableau Charts: Pareto chart

Updated: Oct 8, 2020

The series, Tableau charts has always focused on one thing, helping Tableau users learn how to create different charts and graphs hence equipping them with different techniques of telling each data story. Therefore, inspired by the mission of this series, this post will guide you on how to create a Pareto chart in Tableau.

**What is a Pareto chart in Tableau? **

Pareto is a chart derived from the Pareto principle (also known as 80/20 rule). It states that, for many events 80% of the outcomes come from 20% of the causes.

Using Superstores data set pre-loaded with Tableau app, I am going to create a Pareto chart to help me find-out the **States** contributed 80% of all **Profits **generated for the superstores. (Note; in your own set-up, you'll find an appropriate problem to solve using this technique).

Once you're connected to Superstores data set above,..

Drag dimension

**State**to the**Columns**shelf.Drag measure field

**Profit**to the**Rows**shelf. (Note, aggregate level is**SUM()**).

See the resulting chart,...

Sort **State** in descending order by **Profit**..

Duplicate the chart. To do this, Hold down **Crtl** key and drag the field **SUM(Profit)** on the **Rows** shelf next to itself. See below.

Add a quick Table calculation by computing **Running Totals** for one of the charts. See below.

Add a secondary Table calculation to compute '**Percent of Total**'. (Note, All these Table calculations are computed using dimension **State**).

Executing above, changing the chart type of the first chart to a '**Line**' and renaming the axis '**Percent**', we've.

Making the chart dual results to our final chart. See below.

Lets now find the **States** generated 80% of all Profits.

Extending my selection to view **States** i have.

From above, we can say. Approximately 80% of **profits** generated came from five States; namely, California, New York, Washington, Michigan and Virginia.

I hope this article was helpful to you.

Thanks for reading.