How to turn a bar chart into a pareto?

[info-rchitect]

Hi,

First Dataiku folks should know that if you try to search for 'pareto' on this website, it will always turn it into 'parent'.

Second, how can I turn a bar chart into a parto where the bars are ordered by the highest value first?

thx

---

Operating system used: Windows 10

[LouisDHulst · Accepted solution]

Hi,

You'll want to select the 'Mix' chart in the the chart type options first ( which lets you include both bars and lines).

Then you want to put your Y column in twice:

Set one of the Y columns to have a Normal compute and display on the left axis as a column. You can do this by clicking on the arrows next to the column name.

Then set the other Y column to be a cumulative percentage scale and to display on the right axis as a line.

Finally set your X column to sort by descending order:

This gives you a graph like this: