Tabulate Pass_Fail % of Total

[#1]

I have scouring the boards and can't find any information or examples on how to tabulate a Pass_Fail column where i have a column of 15 different wafers. I can do it for 1 wafer but I don't understand how to group the wafers, then tabulate the yield like the picture below. I have attached a sample table. 

Thanks in advance

[#2]

Use the Tables > Stack command to combine the 15 columns into one column and automatically create a label column (identify original source column) before using Tabulate.

[#3]

I am still a little confused.. Attached is the actual table that we use.. I have an additional column called Row_Pass_Fail which just assigns pass/fail based on all 15 tests.

Thanks

[#4 · Accepted solution]

@Yngeinstn ,

It is unclear how columns 1 - 32 factor into the analysis. Should they be included into the total of Pass and Fail.  Below is a screenshot of:

• Only column 1. If 1-32 should be included a total column might be needed or stacking 1-32 as  Mark,@Mark_Bailey, suggested. Or should the column Pass/Fail should be used instead? If Pass/Fail should be used, replace it for :1 in the description below.
• Modified the Column Property, value ordering for :1, 1(=Pass) is first and 0 (=Fail) second.
• Modified column :1 to be Nominal modeling type.
• Tabulate, drag Wafer to the left, :1 to the Top and drag statistic Row% to the top.
• I dragged N to the top, because as a statistician, I always want to know N. 

The JSL folows the screenshoot

Tabulate(
	Add Table(
		Column Table( Statistics( Row % ), Grouping Columns( :Name( "1" ) ) ),
		Column Table( Statistics( N ) ),
		Row Table( Grouping Columns( :wafer_number ) )
	)
)

The JSL below produces a display of where the failures on the wafer occur, with row, col and subrow and subcol changed to Nominal modeling type.

Graph Builder(
	Variables(
		X( :subcol ),
		Y( :subrow ),
		Page( :wafer_number ),
		Group X( :colnum ),
		Group Y( :rownum ),
		Color( :Name( "Row Pass/Fail" ) )
	),
	Elements( Points( X, Y, Legend( 7 ) ) ),
	SendToReport(
		Dispatch( {}, "subcol", ScaleBox, {Label Row( Show Major Grid( 1 ) )} ),
		Dispatch( {}, "subrow", ScaleBox, {Label Row( Show Major Grid( 1 ) )} ),
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				7,
				Properties(
					0,
					{gradient( {Width( 12 ), Reverse Labels( 1 )} )},
					Item ID( "Row Pass/Fail", 1 )
				)
			)}
		)
	)
) 

 

Or to look at an aggregate wafer

Graph Builder(
	Size( 593, 555 ),
	Show Control Panel( 0 ),
	Variables(
		X( :subcol ),
		Y( :subrow ),
		Group X( :colnum ),
		Group Y( :rownum ),
		Color( :Name( "Row Pass/Fail" ) )
	),
	Elements( Heatmap( X, Y, Legend( 8 ) ) ),
	SendToReport(
		Dispatch( {}, "subcol", ScaleBox, {Label Row( Show Major Grid( 1 ) )} ),
		Dispatch( {}, "subrow", ScaleBox, {Label Row( Show Major Grid( 1 ) )} ),
		Dispatch(
			{},
			"400",
			ScaleBox,
			{Legend Model(
				8,
				Properties(
					0,
					{gradient( {Width( 12 ), Reverse Labels( 1 )} )},
					Item ID( "Row Pass/Fail", 1 )
				)
			)}
		)
	)
)0  

[#5]

@gzmorgan0

I can't thank you enough for what you have provided. The process of the tabulation had me for a loop. I also really need to give you my sencere gratitude for the wafer maps. I have been struggling to get the row, column, subrow, subcol to work using the Semi-Conductor tool kit.

Thank you again.