BookmarkSubscribe
Choose Language Hide Translation Bar
Highlighted
adam
Community Trekker

Populating yield by variable

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

 

WWTest_StnMat_supplierBase_suppliern_qtyn_passn_fail
10Burn in3CMN15132
10Burn in3CMN20182
10Burn in3CMN18180
10Burn in5AMN15150
10Burn in5AMN16151
10Final3CMN15132
10Final3CDA15150
10Final5ADA18171
10Final5ADA16160
10Final5ADA20200
11Burn in5ADA16133
11Burn in5ADA17152
11Burn in5ADA18171
11Burn in3CMN17170
11Burn in3CMN15132
11Final5AMN16151
11Final5AMN16160
11Final3CDA18162
11Final3CDA16142
11Final3CDA19172
12Burn in3CDA17143
12Burn in3CDA19181
12Burn in5ADA20164
12Burn in5ADA20182
12Burn in5AMN15150
12Final5AMN15150
12Final5AMN16142
12Final3CMN18162
12Final3CDA18171
12Final3CDA17152
0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
adam
Community Trekker

Re: Populating yield by variable

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

Re: Populating yield by variable

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?

adam
Community Trekker

Re: Populating yield by variable

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