Hi Guys:
I have raw data like below, I want to create a pareto chart with below data, and the X axis is the Defect level 1 and defect level 2, I hope the two level can be drilled, and the Y axis is the qty of the defect, I tried but my chart can't be drilled, could you tell me how to make it?
Defect Level 1 | Defect Level 2 | Supplier | Defect Qty |
A1 | A | Apple | 1 |
A1 | A | Apple | 1 |
A2 | A | Apple | 1 |
A3 | A | Apple | 1 |
A4 | A | Apple | 1 |
B0 | B | Apple | 1 |
B1 | B | Apple | 1 |
B1 | B | Apple | 1 |
B2 | B | Orange | 1 |
B0 | B | Orange | 1 |
C1 | C | Orange | 1 |
C2 | C | Orange | 1 |
C1 | C | Orange | 1 |
C0 | C | Orange | 1 |
C1 | C | Orange | 1 |
A1 | A | Orange | 1 |
C2 | C | Pineapple | 1 |
B3 | B | Pineapple | 1 |
B2 | B | Pineapple | 1 |
B0 | B | Pineapple | 1 |
C1 | C | Pineapple | 1 |
C2 | C | Pineapple | 1 |
You can use "drill down combo" or "drill down combo pro" of zoom charts from get more visuals.
Please mark my solution as accepted if it helped you!
Hi Dhairya:
Thanks for your reply, and I think the chart can meet our requirements, I may need to create some measures to create the pareto chart.
yes you have to create mesures as per requirements and plot them in required heirarchy.
Please mark my solution as accepted if it helped you!
Thank you!