nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Local data filter

ChrisNally

Control Chart(
	Sample Label( :C_LOT_NAME ),
	Group Size( 1 ),
	KSigma( 3 ),
	Chart Col(
		:Average Pigment Strength,
		Individual Measurement( Show Zones( 1 ), Shade Zones( 1 ) ),
		Capability(
			Distribution(
				Automatic Recalc( 1 ),
				Continuous Distribution(
					Column( :Average Pigment Strength ),
					Quantiles( 0 ),
					Summary Statistics( 0 ),
					Outlier Box Plot( 0 ),
					Normal Quantile Plot( 1 ),
					Capability Analysis( LSL( 13.5 ), USL( 14.5 ), Sigma( 0.0783611176186691 ) )
				),
				Local Data Filter( Add Filter( columns( :C_LOT_NAME ) ) )
			)
		)
	)
);

I am trying to add a script to run a local data filter to a capability analysis:

Any help would be much appreciated

I am getting an error message - Unexpected end of input, trying to parse arguments of function |!"Chart Col |!"."

Thanks

Chris

Accepted answers

All comments

txnelson

What you need to do, to get the proper script for your analysis, is to first run the analysis interactively, and then once you have it setup the way you want it......including the Local Data Filter, then just go to the red triangle for the Control Chart Builder, click on it, and select

Save Script==>To Script Window

and it will give you the completed script.

ChrisNally

Hi Jim

Thanks for quick reply.

Strange one this! If I just run the capability and copy script as you advise then all looks fine, I get the run chart and capability analysis on same window. If I then put on a local data filter and check script under the red triangle then neither the local filter nor capability script shows up!

Capability only

Control Chart(
	Sample Label( :C_LOT_NAME ),
	Group Size( 1 ),
	KSigma( 3 ),
	Chart Col(
		:Average Pigment Strength,
		Individual Measurement( Show Zones( 1 ), Shade Zones( 1 ) ),
		Capability(
			Distribution(
				Continuous Distribution(
					Column( :Average Pigment Strength ),
					Quantiles( 0 ),
					Summary Statistics( 0 ),
					Outlier Box Plot( 0 ),
					Normal Quantile Plot( 1 ),
					Capability Analysis( LSL( 13.5 ), USL( 14.5 ), Sigma( 0.092069130588337 ) )
				)
			)
		)
	)
)

+ Local Data Filter

Control Chart(
	Sample Label( :C_LOT_NAME ),
	Group Size( 1 ),
	KSigma( 3 ),
	Chart Col( :Average Pigment Strength, Individual Measurement( Show Zones( 1 ), Shade Zones( 1 ) ) )
)

What I can get is the relevant capability and data filter script from the 'Capability' red triangle and paste it into my main script, but this gives the run chart and the capabilty/data filter on a seperate window. Feel like i'm almost there but not quite.

Distribution(
	Automatic Recalc( 1 ),
	Continuous Distribution(
		Column( :Average Pigment Strength ),
		Quantiles( 0 ),
		Summary Statistics( 0 ),
		Outlier Box Plot( 0 ),
		Normal Quantile Plot( 1 ),
		Capability Analysis( LSL( 13.5 ), USL( 14.5 ), Sigma( 0.092069130588337 ) )
	),
	Local Data Filter( Add Filter( columns( :C_LOT_NAME ) ) )
);

Thanks

Chris

gzmorgan0

Try this the key is obj << Capability. This is using a JMP sample data table

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Quality Control/Coating.jmp" );
dt:Sample << Modeling type("Nominal");

obj = dt << Control Chart(
	Sample Label( :Sample ),
	Group Size( 1 ),
	KSigma( 3 ),
	Chart Col( :Weight),
	  Chart Type(Individual Measurement),
	  Show Zones( 1 ), Shade Zones( 1 ) 
    );
    
 obj << Capability(
			Distribution(
				Automatic Recalc( 1 ),
				Continuous Distribution(
					Column( :Weight ),
					Quantiles( 0 ),
					Summary Statistics( 0 ),
					Outlier Box Plot( 0 ),
					Normal Quantile Plot( 1 ),
					Capability Analysis( LSL( 16 ), USL( 24 ), Target(20) )
				),
				Local Data Filter( Add Filter( columns( :Sample ) ) )
			)
  
);

gzmorgan0

oops, looks like Jim already answered this.

ChrisNally

Good Morning

Thanks for reply. I thought I was close as no longer getting errors but when I run this I get the Run chart and the distributions OK but no data filter (feel like i'm close!), i'm a Plant chemist rather than a programmer so kind off get by with trial and error. Tried using your suggestion but unfortunately still no data filter. Thanks, always appreciate the help as a bit of a struggle at times for me.

Control Chart(
Sample Label( :C_LOT_NAME ),
Group Size( 1 ),
KSigma( 3 ),
Chart Col(
:Average Pigment Strength,
Individual Measurement( Show Zones( 1 ), Shade Zones( 1 ) );
Capability(
Distribution(
Automatic Recalc( 1 ),
Continuous Distribution(
Column( :Average Pigment Strength ),
Quantiles( 0 ),
Summary Statistics( 0 ),
Outlier Box Plot( 0 ),
Normal Quantile Plot( 1 ),
Capability Analysis( LSL( 13.5 ), USL( 14.5 ), Sigma( 0.0783611176186691 ) )
),
Local Data Filter( Add Filter( columns( :C_LOT_NAME ) ) )
) ) );

If I add this piece of script below the one above I do get the Distribution and local data filter in a seperate window without the run chart:

Distribution(
Automatic Recalc( 1 ),
Continuous Distribution(
Column( :Average Sample Conductivity ),
Quantiles( 0 ),
Summary Statistics( 0 ),
Outlier Box Plot( 0 ),
Normal Quantile Plot( 1 ),
Capability Analysis( LSL( 1.2 ), USL( 2.7 ), Sigma( 0.0690324131402561 ) )
),
Local Data Filter( Add Filter( columns( :C_LOT_NAME ) ) )
);

Regards

Chris