Please help me filter out +/- 6 sigma and then replot

Rehrig76 — Wed, 25 Oct 2017 23:01:07 GMT

Hi all,

In the data I'm trying to plot, I've got a couple spurious data points that are skewing the average and control limits. I want to hide and exclude these data points, and then replot the data with my JMP script. Here is the part of the script that is plotting the data, marking the data points outside of +/- 6 sigma, and is supposed to be filterin them out of the final plots:

rpt = Control Chart Builder(
	Size( 682, 464 ),
	Show Two Shewhart Charts( 0 ),
	Show Control Panel( 0 ),
	Show Capability( 0 ),
   Variables( Subgroup( :TEST_DATE ), Y( :INFL_WL_MED ) ),
   // Add a cusom warning test to mark points outside of +/- 6 sigma
   Customize Tests( Test 1( 6, "1" ) ),
   Chart( Position( 1 ), Limits( Sigma( Moving Range ) ), Warnings( Test 1( 1 ) ) ),
   By( :EPI_RUN, :TEST_SYSTEM )
);
 
// create the summaries table (contains a column showing test failures)
dt_sum = obj << save summaries;
 
// clear any existing row states
dt << clear row states();
 
// loop through each row in the summary table looking for failures
for each row( dt_sum,
   // if this row did not meet our criteria, select the corresponding row in the main table
   If( :Test Failures == "1",
       dt << Select Rows( Row() )
   )
);
 
// Hide exclude all of the selected rows.
dt << Hide and Exclude( 1 );
dt << clear select();

The script marks the data points outside +/- 6 sigma, but the outliers aren't getting getting filtered out, and the data isn't getting replotted. Any help would be greatly appreciated.

Thanks,

-Mike

Re: Please help me filter out +/- 6 sigma and then replot

txnelson — Wed, 25 Oct 2017 23:44:02 GMT

You need to turn the Automatic Recalc option on. This will force the Chart Builder to recalc when the Row States are changed. Here is an example from the Scripting Index

Help==>Scripting Index==>Control Chart Builder==>Automatic Recalc

Names Default To Here( 1 );
dt = Open(
	"$SAMPLE_DATA/Quality Control/Coating.jmp"
);
obj =
Control Chart Builder(
	Variables( Y( :Weight ), Subgroup( :Sample ) )
);
obj << Automatic Recalc( 1 );
dt << Select Rows( 5 ) << Exclude( 1 );

topic Please help me filter out +/- 6 sigma and then replot in Discussions

Please help me filter out +/- 6 sigma and then replot

Re: Please help me filter out +/- 6 sigma and then replot