Tip of the Week

Creating page specific filtering with Filtering Schemes

By default, when you create an Analysis file, filtering is global and affects all the pages in the Analysis. This means if you filter something on one page, it will affect visualizations on other pages for the same data table.

In some cases, this is the desired effect, especially when you use one page to make selections and then you use a subsequent page to show details of those selections.  However, in many other cases, you may want to limit filtering to be specific to a page or some pages.  This can be accomplished by using multiple Filtering Schemes in your Analysis file. To turn on multiple Filtering Schemes, goto Edit > Document Properties, and then make the Filtering Schemes tab active.  On that tab, check the ‘Show filtering scheme menu in Filter Panel’ checkbox. It is on this tab, you can also create additional filtering schemes. 


Once you are done, you can click OK, and you will now see a new section in the top of each Filter Panel which allows you to select which Filtering Scheme you want to apply to the current Page.

You can create as many Filtering Schemes as you would like and then apply them to various pages as needed. 


When would this be useful? Anytime you had an analysis file but wanted to break down the analysis into various categories, and show the results per category.  For example, suppose you are creating an Analysis file for that will show data across 3 major regions (North America, EMEA, and APJ). You may want to setup the Analysis so that there are  a couple pages for all the data combined, then a couple pages specific to each region.  In this case, you setup a Filtering Scheme for each region and also for one global view of your data. Then, you select the appropriate Filtering Scheme for each page.  In each Filtering Scheme, you filter the data to only show the rows specific to either a region or one for the global view.   


While a topic like Filtering Schemes is a very powerful topic, it may not be the most intuitive to understand and locate without proper training. In fact, our Essentials training course for users covers many features and functionality which may go unnoticed inside TIBCO Spotfire Professional. Users who have been using Spotfire for years still find value and learn something new when attending these courses. See the following commercial to learn for yourself.

If you are interested in attending any of our Essentials training courses, using classroom or blended delivery, please visit our user pathway page to learn more about the course and its schedule.


 

Comments

 

EranS said:

Hi Kevin,

This is a very important note for all versions of spotfire.

Please mention the earliest version it applies to.

Thanks,

Eran

August 24, 2010 7:40 AM
 

Kevin Hanegan said:

Filtering Schemes go back as far as I can remember...possibly TIBCO Spotfire version 1 (when it was called DXP), but definitely in 2.0 and Im not sure anyone has a version before that anyways.

August 25, 2010 3:21 PM
 

JohnJustus said:

Good tip Kevin.

How about a Tip on, how to have a single filter when multiple visualization is involved in a page with multiple data tables (This is important).

Another tip would be single Data table, multiple visualization in the page,Certain filter should work for only to certain Visualizatiuon in the page

Thanks..

September 23, 2010 10:23 AM
 

JohnJustus said:

Hi Kevin,

Any updates or is my explanation wrong? Please advice.

Thanks..

September 24, 2010 10:05 AM
 

Kevin Hanegan said:

Hi John,

Are you asking for a filter that works on just a single visualization but not on any other visualization in the page? If so, there is no way to do that currently in the product, but you can work around it using property controls and expressions. Is that what you are interested in seeing?

October 11, 2010 12:04 PM
 

uggkensington said:

http://www.uggkensingtons.org/

http://www.uggkensingtons.org/ugg-fox-fur-short-boots-5531-c-54.html | UGG Fox Fur Short Boots 5531

http://www.uggkensingtons.org/ugg-kensington-boots-5678-c-2.html | UGG Kensington Boots 5678

http://www.uggkensingtons.org/ugg-rainier-eskimo-boots-5189-c-85.html | UGG Rainier Eskimo Boots 5189

http://www.uggkensingtons.org/ugg-retro-cargo-boots-1895-c-3.html | UGG Retro Cargo Boots 1895

December 27, 2011 8:13 PM
 

uggskensingtonsale said:

www.uggskensingtonsale.org

www.uggskensingtonsale.orgugg-adirondack-boots-ii-c-6.html | UGG Adirondack Boots II

www.uggskensingtonsale.orgugg-adirondack-tall-boots-c-11.html | UGG Adirondack Tall Boots

www.uggskensingtonsale.orgugg-amberlee-boots-c-34.html | UGG Amberlee Boots

www.uggskensingtonsale.orgugg-annabelle-boots-c-35.html |

December 28, 2011 4:02 AM
 

uggretrocargosale said:

January 4, 2012 8:48 PM

Leave a Comment

(required) 
(optional)
(required) 
Submit

Syndication

Other Spotfire Blogs

Spotfire's interactive information visualization and analytic solutions give users a remarkable experience for quickly and easily querying data and reporting results for superior business intelligence. From portfolio management and customer retention programs to key processes such as CRM, marketing, research, bioinformatics, yield and asset management and design for manufacturing, enterprises around the world rely on Spotfire's business analytics software to improve operational performance.

©Copyright 2000-2011 TIBCO Software Inc | Privacy Policy | Terms of Use I Blog I Contact Us I Content Center