Filters are used to show results for a sub-group of interest. This article explains filtering, how to create, apply, and modify filters, how to quickly create lots of filters, and how to put filter controls onto pages.
What is filtering?
The table on the left shows the percentage of people in a sample of 895 to select each of the companies as their main phone company. The table on the right has only been computed for the 435 males in the sample; such a table is known as a filtered table.
When you create a filter, it appears in the data set as an additional variable. Notice that a new Gender is Male filter variable has been created under Data Sets.
If you wish to modify the filter, you select the filter variable, and press the Edit filter button in the object inspector.
Apply a Filter
Once you have created a filter, you can re-apply it by clicking the Filter(s) dropdown and selecting it. The box will go green, as shown below.
Note that you cannot necessarily filter everything. For example, if a visualization is hooked up to a table, you need to filter the table, not the visualization, in order to see a filtered visualization.
Quickly creating lots of filters
- Selecting the variables.
Click Anything > Filter > Filters from Selected Data.
The filters will appear as Binary - Multi variable sets:
Creating filter controls on pages
If creating an online report/dashboard, or performing report automation, it can be useful to have controls on pages that allow people in view mode to set and change filters. For example, the page below allows users to filter by sex.
Controls that filter data are placed on a page by:
- Clicking on whatever needs to be filtered (e.g., a table, the entire page).
- Pressing one of Combo Box Filters, List Box Filters, or Text Box Filters.
Watch a filtering walk-through