When you have filtered data in your analysis, it is possible to display the following three categories; the data that is filtered to, the data that is filtered out, and the entire data. These categories can be compared in a single visualization by selecting the (Subsets) option in a column selector.
Which categories to compare in a visualization is specified in its Properties popover, the Compare subsets section.
To put the settings in effect, you select the (Subsets) option in the column selector of interest.
Example of comparing filtered data to all data
The bar chart is based on the data table above, and it shows the total sales for stores in four cities.
Assume you are interested in examining how much was spent by men only, and therefore filter to Male in the Gender column. The result is shown below:
Using subsets, you can display the eight bars above simultaneously in the bar chart by first selecting the All data and the Current filtering check boxes in the Properties popover:
Then select (Subsets) for example on the Color by axis, and you will be able to compare the two categories in the bar chart.
Using a different version of Spotfire?This help describes the web client version of Spotfire on TIBCO Cloud™. If you're looking for documentation for the installed client or other versions of Spotfire, visit the TIBCO Documentation Portal.