Is there an option (checkbox or setting) in Jmp to tell a data filter to exclude excluded rows from the lists?
Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Data Filter(
Location( {265, 175} ),
Mode( Select( 0 ), Include( 1 ) ),
Add Filter(
columns( :age, :sex ),
Where( :age == {12, 14, 16} ),
Where( :sex == "F" ),
Display( :age, N Items( 6 ) )
)
);
dt << New Column( "excluded", Character, "Nominal", set each value( If( Excluded(), "(excluded)", "" ) ) );
dt << New Column( "age_", Character, "Nominal", set each value( Char( :age ) || " " || :excluded ) );
dt << New Column( "sex_", Character, "Nominal", set each value( :sex || " " || :excluded ) );
gb = dt << Graph Builder(
Size( 534, 498 ),
Show Control Panel( 0 ),
Summary Statistic( "Median" ),
Graph Spacing( 4 ),
Variables( X( :height ), Y( :weight ) ),
Elements( Points( X, Y, Legend( 6 ) ), Smoother( X, Y, Legend( 7 ) ) )
);
df = gb << Local Data Filter(
Conditional,
Add Filter(
columns( :excluded, :age_, :sex_ ),
Where( Is Missing( :excluded ) )
)
);
wait(4);
gb << Remove Local Data Filter();
df = gb << Local Data Filter(
Add Filter(
columns( :age_, :sex_ )
)
);