Control chart warning - in table format to email

Lichun

Hi Team,

 

             For current control chart warning to email.

            (I try to search it from JMP discussion but not able to find similar discussion, please help on it). 

             Q1. 

             Scenario: 50 WAT items, run control chart alarm, there are 10 items with SPC rule violation.

             1. Can we run JSL to summary the alarm item in table format- and mentioned the violation rule. 

             2. Can we have a link for each of items (link to somewhere like cloud) or send the control chart in attached file for the rule violation item ?

 

Thanks

Byron_JMP

this example is from the scripting index for saving the summary to a new table via JSL

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Quality Control/Coating.jmp" );
obj = dt << Control Chart Builder( Variables( Y( :Weight ), Subgroup( :Sample ) ) );
obj << Save Summaries;

for #2, if you include a link you can make the table or data points go to the link

 

this is an old example from Ian Cox that might help to get you started.

 

dt = New Table( "ActionOnRowSelect",
			Add Rows( 5 ),
			New Property( "Bivariate",
				Bivariate(
					Y( :Y ),
					X( :X ),
					SendToReport(
						Dispatch(
							{},
							"Bivar Plot",
							FrameBox,
							Marker Drawing Mode( Outlined )
						)
					)
				)
			),
			New Column( "Selected Row",
				Numeric,
				Nominal,
				Format( "Best", 16 ),
				Formula(
					If( Selected( Row State( Row() ) ),
						Eval( Parse( :script ) );
						1;
					,
						0
					)
				)
			),
			New Column( "script",
				Character,
				Nominal,
				Set Values(
					{"Bivariate(Y( :X), X( :Y));", "Beep(); Dialog(\!"Hello 1\!")",
					"Beep(); Dialog(\!"Hello 2\!")", "Beep(); Dialog(\!"Hello 3\!")",
					"Web(\!"http://www.jmp.com\!", JMPWindow)"}
				)
			),
			New Column( "X",
				Numeric,
				Continuous,
				Format( "Best", 10 ),
				Set Values( [1, 2, 3, 4, 2] )
			),
			New Column( "Y",
				Numeric,
				Continuous,
				Format( "Best", 10 ),
				Set Values( [4, 3, 2, 1, 5] )
			)
		);
Column(dt, "Selected Row") << Hide;
Column(dt, "Script") << Hide;