Populating yield by variable

[#1]

Hi,

I have a problem as shown below(not actual case though). I guess I can use Analyze - Tabulate for a simple dataset however in actual case, I have about 50 variables and 1million rows and it's going to be huge or simply time consuming to do it one by one. I would like to know from example below, how can calculate the yield(n_pass/n_qty * 100) by Test_Stn and parts supplied(in this case, Mat_supplier and Base_supplier). For instance, the expected result will be Yield by Test_Stn - Burn in, x%, Final, y% and Mat_supplier; 3C, a% and 5A, b% spread across the WW. It doesn't matter if the result is populated into new data table.

Thanks.

Adam

WW	Test_Stn	Mat_supplier	Base_supplier	n_qty	n_pass	n_fail
10	Burn in	3C	MN	15	13	2
10	Burn in	3C	MN	20	18	2
10	Burn in	3C	MN	18	18	0
10	Burn in	5A	MN	15	15	0
10	Burn in	5A	MN	16	15	1
10	Final	3C	MN	15	13	2
10	Final	3C	DA	15	15	0
10	Final	5A	DA	18	17	1
10	Final	5A	DA	16	16	0
10	Final	5A	DA	20	20	0
11	Burn in	5A	DA	16	13	3
11	Burn in	5A	DA	17	15	2
11	Burn in	5A	DA	18	17	1
11	Burn in	3C	MN	17	17	0
11	Burn in	3C	MN	15	13	2
11	Final	5A	MN	16	15	1
11	Final	5A	MN	16	16	0
11	Final	3C	DA	18	16	2
11	Final	3C	DA	16	14	2
11	Final	3C	DA	19	17	2
12	Burn in	3C	DA	17	14	3
12	Burn in	3C	DA	19	18	1
12	Burn in	5A	DA	20	16	4
12	Burn in	5A	DA	20	18	2
12	Burn in	5A	MN	15	15	0
12	Final	5A	MN	15	15	0
12	Final	5A	MN	16	14	2
12	Final	3C	MN	18	16	2
12	Final	3C	DA	18	17	1
12	Final	3C	DA	17	15	2

[#2]

Maybe I'm not fully understanding your dilemma but can't you just write a simple formula for Yield in the JMP formula editor, then depending on your other criteria I could envision using the Tabulate platform for creating the groups, sub groups, etc. Or maybe for a more visual approach use Graph Builder and the layering/nesting of variables in the x drop zone or group drop zone or combined with maybe column switcher or a local data filter?

[#3 · Accepted solution]

Hi Pete,
I think I got the point now. Yup, I will write a simple formula for that.
Thanks a lot.