Subscribe Bookmark RSS Feed

Close Local Data Filter Outline Box

pmroz

Super User

Joined:

Jun 23, 2011

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.

7391_Local Data Filter Closed.png

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

7392_Local Data Filter Open.png

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:

7393_Local Data Filter from Script.png

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

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 );

2 REPLIES
Solution

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 );

pmroz

Super User

Joined:

Jun 23, 2011

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.