Issue with control charts and data tables with columns with different amount of data in them

Question

I have a customer who is monitoring a process with several control charts.  Different monitors have different frequency of data collected.  His data starts out as stacked data.  When the data is split, the columns have different number of values.  The number of rows is set by the data with the most number of values.  Other parameters have missing values to fill out the table.  See below for a screen shot of the data table.

When generating control charts, the charts are bunched up on the left side with a lot of blank area.  Is there a way to avoid this?  See below for a screen shot of the control chart.

The control chart looks like this:

The table looks like this:

Jordan_Hiller · Answer

Column switcher could work with hide and exclude in JMP 16. There's a new jsl option to run a script each time the column switcher is invoked by the user. You could script the hiding/excluding operation.

Here's the example from the scripting index:

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Car Poll.jmp" );
obj = dt << Contingency( Y( :size ), X( :marital status ) );
ColumnSwitcherObject = obj << Column Switcher(
	:marital status,
	{:sex, :country, :marital status}
);
ColumnSwitcherObject << Set Script(
	Print( "New Value: " || Char( ColumnSwitcherObject << Get Current ) )
);
ColumnSwitcherObject << Run;
Wait( 5/*seconds, while it animates*/ );

HydeMiller · Answer

Unfortunately, the customer wants limit lines on the charts (so stacked data doesn't work) and to use column switcher which wouldn't work with hide&exclude.

Jordan_Hiller · Answer

How about hide/exclude the missing rows, then turn off the "Show excluded region" red triangle option? This would have to be toggled when doing control charts on different columns.

The original stacked format might work better with a "By" variable to generate multiple control charts.