Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
Yngeinstn
Level IV

Tabulate Pass_Fail % of Total

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

 

Capture.JPG

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
gzmorgan0
Super User

Re: Tabulate Pass_Fail % of Total

@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,@markbailey, 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

image.png

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 )
				)
			)}
		)
	)
) 

image.png 

 

Or to look at an aggregate wafer

image.png

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  

 

View solution in original post

4 REPLIES 4
Highlighted

Re: Tabulate Pass_Fail % of Total

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.

Learn it once, use it forever!
Highlighted
Yngeinstn
Level IV

Re: Tabulate Pass_Fail % of Total

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

Highlighted
gzmorgan0
Super User

Re: Tabulate Pass_Fail % of Total

@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,@markbailey, 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

image.png

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 )
				)
			)}
		)
	)
) 

image.png 

 

Or to look at an aggregate wafer

image.png

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  

 

View solution in original post

Highlighted
Yngeinstn
Level IV

Re: Tabulate Pass_Fail % of Total

@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.

Article Labels

    There are no labels assigned to this post.