News
On June 1, we’re asking you to select a content label when starting a new topic in the Discussions area. Read more to find out why.
Choose Language Hide Translation Bar
Highlighted
pmroz
Super User

Close Local Data Filter Outline Box

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!

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
ms
Super User ms
Super User

Re: Close Local Data Filter Outline Box

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

View solution in original post

2 REPLIES 2
Highlighted
ms
Super User ms
Super User

Re: Close Local Data Filter Outline Box

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

View solution in original post

Highlighted
pmroz
Super User

Re: Close Local Data Filter Outline Box

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.

0 Kudos