Setting Filters

The filters dialog box located on the left hand side of the Crosstab Builder page allows you to use survey variables as filters in the Data Spreadsheet. Any variable in the questionnaire can be used as a filter. Variables can be added to the filter dialog box individually or as a folder. 

Since filters are usually applied once when creating a report, the filter box can be toggled open or closed. To open the filters dialog box, click the right arrow next the Filters. To close the Filters dialog box, click the close icon.

Selecting Filters

You can add a variable to the filter dialog box by locating the desired variable in the questionnaire using the search bar or scrolling through the variables. After you find the variable you wish to use as a filter, click and drag the individual variable or folder into the filter dialog box. You can add multiple variables and folders to the filter dialog box for ease of access.

Applying Filters

Once you have added the individual variables or folders to be used as filters to the filter dialog box, click the Calculate button in the upper right hand corner of the Crosstab Builder page to apply the filter(s) to the Data Spreadsheet.

Viewing the Filtered Data

If you have added multiple variables to the filter dialog box and they are active, a separate tab will be created at the bottom of the Data Spreadsheet for each variable.

Removing Filters

You can remove variables from the filter dialog box by selecting the variable, right clicking on the variable, and then clicking remove. You can also deactivate variables by unchecking the red box next to the variable. As always, after you have made changes in the filter dialog box click the Calculate button in the upper right hand corner of the Crosstab Builder page to apply the changes.

NOTE: Removing or deactivating a variable will delete the tab created for that filter on the Data Spreadsheet.



Other articles in this section: