topic Close Local Data Filter Outline Box in Discussions

Close Local Data Filter Outline Box

pmroz — Tue, 18 Oct 2016 21:47:49 GMT

Hello all,

I'm trying to create a graph with a local data filter pre-added to it. To save a bit of time I'm also ordering the filter elements by count. I want the graph to look like this initially. As you can see the local data filter is there, and it's outline box is closed.

When you open the local data filter this is what you should see. Notice that the items are ordered by count

When I save the script from the first graph this is the code:

dt = open("$sample_data\Bands Data.jmp");

dt << Graph Builder(

Show Control Panel( 0 ),

Variables( X( :timestamp ), Y( :viscosity ), Overlay( :customer ) ),

Elements( Points( X, Y, Legend( 1 ), Jitter( 1 ) ) ),

Local Data Filter(

Location( {399, 178} ),

Mode( Select( 0 ), Show( 1 ), Include( 1 ) ),

Add Filter(

columns( :customer ),

Display( :customer, Size( 204, 194 ), List Display ),

Order By Count( :customer )

)

);

However when I run the script the local data filter outline box is open, and the items are not ordered by count:

So my questions are these:

1. Is there a way to close the outline box holding the local data filter upon first display of the graph?

2. Why isn't order by count working?

Thanks!

Re: Close Local Data Filter Outline Box

ms — Tue, 07 Oct 2014 15:51:20 GMT

Order by count appears to work if creating the objects separately. See last line for one way to close the outline box:

dt = Open( "$sample_data\Bands Data.jmp" );

gb = dt << Graph Builder(

Show Control Panel( 0 ),

Variables( X( :timestamp ), Y( :viscosity ), Overlay( :customer ) ),

Elements( Points( X, Y, Legend( 1 ), Jitter( 1 ) ) ),

);

ldf = gb << Local Data Filter( Add Filter( columns( :customer ), Display( :customer, Size( 208, 202 ), List Display ), ) );

ldf << (Filter Column( :customer ) << Order by Count( 1 ));

(gb << top report)[Outline Box( "Local Data Filter" )] << Close( 1 );

Re: Close Local Data Filter Outline Box

pmroz — Tue, 07 Oct 2014 16:52:57 GMT

Thanks MS! - I figured you'd need to use the display tree to close the outline box but I'm not familiar with how to do that.