BookmarkSubscribe
Choose Language Hide Translation Bar
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.

 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
1 ACCEPTED SOLUTION

Accepted Solutions
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.
2 REPLIES 2
Staff

## 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?

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.