BookmarkSubscribe
Choose Language Hide Translation Bar
fanienel
Community Trekker

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?

0 Kudos
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.

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
Community Trekker

Re: Using a local data filter in a combined report

Thank you Phil, that worker perfectly

Fanie

0 Kudos
Niall
Community Trekker

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

0 Kudos
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? 

0 Kudos
Niall
Community Trekker

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
0 Kudos
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
0 Kudos