- Bernard

# Tableau Charts: Pareto chart

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, we’ll explore 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 T__ableau app__, we are going to create a Pareto chart to help us find the **States** which contributed 80% of all **Profits **generated for the superstores. (Note; in your own set-up, you'll find other appropriate problems 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 Aggregates. 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.