How to turn a bar chart into a pareto?

info-rchitect
info-rchitect Registered Posts: 180 ✭✭✭✭✭✭

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
    LouisDHulst Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Neuron, Registered, Neuron 2023 Posts: 54 Neuron
    Answer ✓

    Hi,

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

    image.png

    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.

    image.png

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

    image.png

    Finally set your X column to sort by descending order:

    image.png

    This gives you a graph like this:

    image.png

Setup Info
    Tags
      Help me…