Forum Discussion
Pareto Chart with multiple level
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 |
3 Replies
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!
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!
