topic Re: Adding Spec limits in variability-attribute gauge chart in Discussions

Adding Spec limits in variability-attribute gauge chart

Vmuthu — Fri, 09 Jun 2023 23:25:34 GMT

I have a table with 100 devices, and 300 test items tested. I have spec columns separately contains LSL, USL. I want to plot the variability-attribute gauge chart with the spec limits in it. Please show me how to do it or if there is any existing discussion in this topic, please point it to me. thanks.

Sample data table:

Device	Test Name	Measurement	LSL	USL
1	Test1	230	200	240
1	Test2	20	15	25
1	Test3	30	25	35
2	Test1	234	200	240
2	Test2	22	15	25
2	Test3	29	25	35
3	Test1	229	200	240
3	Test2	21	15	25
4	Test1	230	200	240
4	Test2	21	15	25

Re: Adding Spec limits in variability-attribute gauge chart

uday_guntupalli — Wed, 05 Dec 2018 02:42:28 GMT

@Vmuthu,
https://community.jmp.com/t5/Discussions/Adding-Control-spec-limits/m-p/7037#M7031

Have you checked the community for similar questions ?

Re: Adding Spec limits in variability-attribute gauge chart

txnelson — Wed, 05 Dec 2018 12:25:20 GMT

The main issue with what you want, is that your data are not in a proper form for running the Variability-Attribute Chart platform. The script below will transform a data table with the columns you have specified, into a data table that can be used to generate the charts you want.

Names Default To Here( 1 );
dt = Current Data Table();

// Make a list of the Tests
Summarize( dt, testList = by( :Test Name ) );

dtSplit = dt << Split(
	Split By( :Test Name ),
	Split( :Measurement, :LSL, :USL ),
	Group( :Device ),
	Sort by Column Property
);

// Rename the test columns and set the Spec Limits
For( i = 2, i <= N Items( testList ) + 1, i++,
 
	// Assign the new names
	Column( dtSplit, i ) << set name( Substr( Column( dtSplit, i ) << get Name, 13 ) );
	
	// Set the Spec Limits
	Eval(
		Substitute(
				Expr(
					Column( dtSplit, i ) << set property(
						"Spec Limits ",
						{LSL( __LSL__ ), USL( __USL__ ), Show Limits( 1 )}
					)
				),
			Expr( __LSL__ ), Col Mean( As Column( dtSplit, i + N Items( (testList) ) ) ),
			Expr( __USL__ ),
				Col Mean( As Column( dtSplit, i + 2 * N Items( (testList) ) ) )
		)
	);
);

// Delete unwanted limits columns
dtSplit << delete columns( Index( N Items( testList ) + 2, N Cols( dtSplit ) ) );

Re: Adding Spec limits in variability-attribute gauge chart

Vmuthu — Thu, 06 Dec 2018 01:11:28 GMT

Thank yoiu txnelson it worked.

Thanks Uday for the suggestion.