How to turn a bar chart into a pareto?
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
Best Answer
-
LouisDHulst Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Neuron, Registered, Neuron 2023 Posts: 54 NeuronHi,
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:
