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

JMP SCRIPT: Control chart based on conditions

Sebastienlg

Hello everyone,

I would like to make control charts based on conditions.

I have two dataset:

1) the first dataset which contains the data for the control charts (with different variables),

2) the second dataset which contains the limits of the control chart. However, this dataset doesn't contain the limits of each variable of the first dataset.

I would like to create the following conditions:

if the limits are available in the (second) dataset, then the limit are imported on the control chart.

However, if there is no limit in the (second) dataset, then no limit are set up on the control chart, and a run chart is developped.

In case there is no limit in the dataset JMP set limits based on the 3 standard deviations...

Does anyone have any suggestion to help me make this condition?

Thank you in advance,

Sebastien

Accepted answers

All comments

txnelson

The JMP platform, Control Chart Builder, has the ability to load limits from a JMP Limits table. Any limits found for a column in the limits table will be applied. If the column is not found, then JMP will apply the standard limits. The limits table can be in ether a wide or tall form

Wide

Tall

Once you have your limits converted into one of these forms, then all that has to be done is to run the Control Chart Builder, specifying the columns to be charted, and telling it to get the limits from your limits table

Control Chart Builder(
	Variables( Y( <your list of column to chart goes here> ) ),
	Get Limits( "<the name of your limits table goes here>" )
);

Sebastienlg

thank's a lot for your answer Jim.

This is already what I have done. However, for few variables, I do not have the limit available in the dataset: Example of the Age variable present below:

_LimitsKey	height	Weight	Age
_UCL	54	80
_LCL	72	150

And when it is the case JMP apply the standard limits (here for the Age variable).

But I would like that JMP doesn't apply any limit in this case and just make a run chart.

I guess I need to make an "if" condition, but I do not know how to create it:

if ( "<the name of your limits table goes here>" )&nbsp;isnot&nbsp;empty

not sure about it...

Do you have any suggestion for this condition?

Sebastien

txnelson

As you suggest you will need to see if the limits are present or not. Here is some pretty rough code to show an approach to use

names default to here(1);

dt= data table("<your data table>");
dtLimits = data table("<your limits table>");

colNames = {<create a list of columns to be processed>};

// Create a window to place all output into
nw = New Window("Charts",
	For(i=1,i<=nitems(colNames), i++,
		If( try(column(dtLimits, colNames[i]) << get name, "") == "" |
			try( col number(column(dtLimits, colNames[i])),0) == 0,
		Control Chart( 
			Chart ( as column(dt,colNames[i]),
				Run Chart(Run Chart( Show Center Line( 0 ) ))
			)
		),
		Control Chart Builder(
			Variables( Y( as column(dt, colNames[i]) ) ),
			Get Limits( dtLimits )
			);
			
		)
	)
);

Sebastienlg

Thank's a lot for your answer Jim.

Almost there I hope... However, it is a bit trickier that I thought

It works well with in case there is no Column switcher...

However, in my case there is a column switcher, which is based on the user selection..

Here is my program:

New Window( "Test", 
	V List Box(
		coltstst = RAW_DATA_TABLE << 
		Column Switcher(:Name("Y"),Y_list),
		
		If( try( col number(column(LIMIT_TABLE, :"Y")),0) == 0 ,
		graph=Control Chart Builder(
				Size( 534, 450 ),
				Show Two Shewhart Charts( 0 ),
				Show Control Panel( 0 ),
				Sort by Row Order( 1 ),
				Show Limit Summaries( 0 ),
				Variables(
					Subgroup( :X ),
					Y( :"Y" ),
					Phase(:"Version")
				),
				Chart(
					Points( Statistic( "Individual" ) ),
					Limits(
						Sigma( "Moving Range" ),
						Show Lower Limit( 0 ),
						Show Upper Limit( 0 )
					)
				),
				SendToReport(
					Dispatch(
						{},
						"Control Chart Builder",
						OutlineBox,
						{Set Title( "Représentation graphique" )}
					)
				)
			),	
		graph = RAW_DATA_TABLE << 
				Control Chart Builder(
					Size( 534, 450 ),
					Show Two Shewhart Charts( 0 ),
					Show Control Panel( 0 ),			
					Sort by Row Order( 1 ),
					Show Limit Summaries( 0 ),
					Variables( Y( :"Y" ),Subgroup( :X ), Phase(:"Version")),	
					Get Limits(LIMIT_TABLE),
				),
		N = N Items( phaseLevels );
		// On met en forme les lignes
		For( i = 1, i <= N Items( phaseLevels ), i++,
			graph << SendToReport(
					Dispatch(
						{},
						"Control Chart Builder",
						OutlineBox,
						{Set Title( "Représentation graphique" )},
						FrameBox( 2 ),
						{
						DispatchSeg( Line Seg( Eval(3*i+N-2) ),		{Line Color( "Medium Light Green" ),Line Style( "Dotted" ), Line Width( 1.5 )} ),
						DispatchSeg( Line Seg( Eval(3*i+1+N-2) ),	{Line Color( "Medium Light Orange" ), Line Style( "Dotted" ), Line Width( 2.5 )}),
						DispatchSeg( Line Seg( Eval(3*i+2+N-2) ),	{Line Color( "Medium Light Red" ), Line Style( "Dotted" ), Line Width( 2.5 )})
						}
					)
				)
			)
		);
	));
	
coltstst << Link Platform( graph );

In that case, the control chart made doesn't add any control limits even if the table_limits contains limits.

Do you have any idea to help me?

Thank's a lot

Sebastien