Count no of entry in column to calculate yield.

Question

How can I Count no of fail and pass by Lot to calculate yield. I want to do this using formula. (Tabulate function is working just fine. But I like to know how to do that using formula)

Untitled 10.jmp

Victor_G · Answer

Hi @hogi,

It is possible but require some work on the datatable:

* Recode Pass to value "0" and Fail to value "1"
* Change column "Result" data type to Numeric and Modeling type to "Nominal"
* Add a column property "Value Labels" to identify what the 0s and 1s mean (and display it in the datatable directly).
* Finally, use "Group by" Lot and "Group by" Result, and create a new formula column based on "Result" column : New Formula Column>Aggregate>Sum. This will lead to this formula in the new column:Col Number( :Result, :Lot, :Result )

@ConfidenceOwl94 please find attached the datatable with the newly created column for the count of Pass/Fail. You can then use this column to calculate %Yield or directly transform the formula in this column to the following formula to get your Yield directly calculated :

(Col Number( :Result, :Lot, :Result ) / Col Number( :Result, :Lot )) * 100

Hope this solution may help you,

Untitled 10.jmp

hogi · Answer

to calculate the yield via a column formula, you can use:

New Column( "yield_",
	Format( "Percent", 9, 2 ),
	Formula( Col Sum( :Result == "Pass", :Lot ) / Col Number( 1, :Lot ) )
)

hogi · Answer

You can use Tabulate:

Drag lot onto the vertical axis and Result onto the header. Then drag Row% onto the main drop zone.
In Column "Pass", you can read the yield in %.

Tabulate(
	Add Table(
		Column Table( Grouping Columns( :Result ), Add Aggregate Statistics( :Result ), Statistics( Row % ) ),
		Row Table( Grouping Columns( :Lot ), Add Aggregate Statistics( :Lot ) )
	)
);