I have a very large dataset of manufacturing defect bin data.
My columns are the manufacturing batch IDs (called lots), and then each column is a defect bin, with the numeric value for that particular defect bin for each lot.
- In JMP Pareto chart, the input needs all defect bins in one column. So, I have to make another table by stacking those defect bins using Table>Stack. This makes an even larger data table. Is there any workaround to this to create the Pareto chart from just the initial table?
- After creating this stacked table, I want to get the pareto chart for each lot. I would usually do that by adding lot to x grouping and then adding a filter by lot to the chart. But this still leaves all the empty graphs for other lots (see below screengrab). How can I cycle through the lots like I can do it in other charts made in graph builder?