Pareto analysis
12 December, 2013
Hi,
How can we realize a Pareto analysis based in YellowFin on the example dataset as attached?
How can we realize a Pareto analysis based in YellowFin on the example dataset as attached?
Hi Yelloobee,
I think you can get what you're after by using a combination chart & advanced functions.
The Pareto chart uses a bar and line to display the breakdown of a metric by category and identify which combination of these makes up the highest percentage share.
E.g.
You can see we have created a report and applied the analytic functions '% of Total' & ' Accumulative %'.
Then using an overlay combination chart, displaying one as a bar, and the other as a line.
Does this give you what you're after?
Regards,
David
I think you can get what you're after by using a combination chart & advanced functions.
The Pareto chart uses a bar and line to display the breakdown of a metric by category and identify which combination of these makes up the highest percentage share.
E.g.
You can see we have created a report and applied the analytic functions '% of Total' & ' Accumulative %'.
Then using an overlay combination chart, displaying one as a bar, and the other as a line.
Does this give you what you're after?
Regards,
David
Hi David,
I managed to follow your advice (see also uploaded results). But in order to make this report more readable, I would have the Suppliers in this report based on the Accumulative % of the PO Amount that are greater than 80% shown as 1 block called "Other Suppliers") as I am not interested in the details of these Suppliers anymore.
Is there a solution in YellowFin for this requirement?
I managed to follow your advice (see also uploaded results). But in order to make this report more readable, I would have the Suppliers in this report based on the Accumulative % of the PO Amount that are greater than 80% shown as 1 block called "Other Suppliers") as I am not interested in the details of these Suppliers anymore.
Is there a solution in YellowFin for this requirement?
Hi,
Sorry for the delay.
Just letting you know I will respond to your query tomorrow.
Busy time of the year :(.
Regards,
David
Sorry for the delay.
Just letting you know I will respond to your query tomorrow.
Busy time of the year :(.
Regards,
David
Hi Yellowbee,
Unfortunately it looks like we cannot do exactly what you're after :(.
You can use a waterfall chart to get a total column, though you cannot put a line on top of this chart.
We're thinking the best way to get what you're after is to have 2 charts.
1 chart will have a filter value that shows all data < 80%. This will have your overlay chart (bar + line).
1 chart will have just the 80% < as a single column.
I know it's not exactly in the 1 chart, though you can co-display the 2 charts, just 1 won't have the line.
Sorry for the delays and inconvenience this has caused.
Regards,
David
Unfortunately it looks like we cannot do exactly what you're after :(.
You can use a waterfall chart to get a total column, though you cannot put a line on top of this chart.
We're thinking the best way to get what you're after is to have 2 charts.
1 chart will have a filter value that shows all data < 80%. This will have your overlay chart (bar + line).
1 chart will have just the 80% < as a single column.
I know it's not exactly in the 1 chart, though you can co-display the 2 charts, just 1 won't have the line.
Sorry for the delays and inconvenience this has caused.
Regards,
David