Hello,
I am trying to create a table of histograms that have had a local data filter applied to only display a subset of the data. However, when I review the pictures in the table, the histograms are displaying plots for all available data. In the sample JSL below. I have used the Semiconductor Capability.jmp sample data file. For example, if the filter is being applied ( for lot_id = "lot09"), all measurements for the PNP5 column should be within spec limits. (I'm not sure if this is pertinent, but I am using JMP 14.3.0 on Windows 10).
Thanks,
AW
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" );
//************************************************************************************************************************************************************************************************************
// Set Graph Reference Limits
//***********************************************************************************************************************************************************************************************************
Wait( 0.5 );
Set_Graph_Lines = Manage Spec Limits( Y( dt << Get Column Group( "Processes" ) ) );
Set_Graph_Lines << Show Limits All( 1 );
Set_Graph_Lines << Save to Column Properties( 1 );
//************************************************************************************************************************************************************************************************************
// Generate Table of Histograms
//***********************************************************************************************************************************************************************************************************
HistPics = New Table( "Table of Histograms",
New Column( "Histograms", Expression, "None", Set Values( {} ),Set Display Width( 300 ) ),
New Column( "Parameter", Character, "Nominal", Set Values( {} ),Set Display Width( 200 ) ) );
// Generate List of Column Names as a list of Strings to Use as parameter column name in datatable cells
//----------------------------------------------------------------------------------------------------------
Cols_List_String = dt << Get Column Names( "String");
Cols_List_String_Cnt = N Items( Cols_List_String );
For( j = 1, j <= Cols_List_String_Cnt, j++,
Gen_Distribution = dt << Distribution(
Column( dt:j ),
Quantiles( 0 ),
Outlier Box Plot( 0 ),
PpK Capability Labeling( 0 ),
Capability Analysis (0),
Frequencies(0),
Summary Statistics(0),
Local Data Filter(
Grouped by AND( 1 ),
Add Filter(
columns( :lot_id ),
Where( :lot_id == "lot09" ),
Display( :lot_id, Size( 181, 136 ), List Display )))
);
pic = (Report( Gen_Distribution )) << getpicture; //Neither local data filter selection nor spec limit reference lines are being captured
Gen_Distribution << closewindow();
ParmName = Cols_List_String[j];
HistPics << addrows( 1 );
HistPics:Histograms[j] = pic;
HistPics:Parameter[j] = ParmName;
);
HistPics<<Set Cell Height( 165 );
Set_Graph_Lines << Close Window;