cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
fanienel
Level I

Using a local data filter in a combined report

I have a combined report with a table, created with tabulate using a local data filter, and a graph. Is it possiLocal Data filter in a combined report?ble to use the same local data filter for both?

1 ACCEPTED SOLUTION

Accepted Solutions
Phil_Kay
Staff

Re: Using a local data filter in a combined report

Yes, this is possible.

First of all, create your application by combining windows
as before. Don’t include a filter at this point.

Then Edit Application (in the Report hotspot).

 

Pick up a Data Filter(Local) object from the Data Table source section and drag-n-drop it into the outline for the report (you can put it wherever you want it).

Then you need to specify where the filter applies to using a Data Filter Context Box. The simplest way is to right click on the Outline1 object in the Objects panel. Then Add Container > Data Filter Control Box.

This application should now work with the filtering in the way that you want.

View solution in original post

6 REPLIES 6
Phil_Kay
Staff

Re: Using a local data filter in a combined report

Yes, this is possible.

First of all, create your application by combining windows
as before. Don’t include a filter at this point.

Then Edit Application (in the Report hotspot).

 

Pick up a Data Filter(Local) object from the Data Table source section and drag-n-drop it into the outline for the report (you can put it wherever you want it).

Then you need to specify where the filter applies to using a Data Filter Context Box. The simplest way is to right click on the Outline1 object in the Objects panel. Then Add Container > Data Filter Control Box.

This application should now work with the filtering in the way that you want.

fanienel
Level I

Re: Using a local data filter in a combined report

Thank you Phil, that worker perfectly

Fanie

Niall
Level I

I'm trying to do somehting similar, but don't get the "Da...

I'm trying to do somehting similar, but don't get the "Data Filter Control Box" option (see image for the options I'm offered) -

 

I must be doing something goffy!

 

Local Data Filter.PNG

 

Thanks in advance

Niall

Phil_Kay
Staff

Re: I'm trying to do somehting similar, but don't get the "Da...

Hi, the original solution was written before Dashboard Builder came about in JMP13. The solution is simpler with Dashboard Builder. Are you using Dashboard Builder? 

Niall
Level I

Re: I'm trying to do somehting similar, but don't get the "Da...

Hi Phil, yeah I'm on JMP13 and got it to work via the Dashboard builder

Thanks
Phil_Kay
Staff

Re: I'm trying to do somehting similar, but don't get the "Da...

Great, Niall. Glad to hear that.
Thanks,
Phil