4.4 Filter data
Use filters when you want to analyze only a subset of your data.
Steps
- Click on the toggle button beside “Filters”.
- Click + New under the Filter bar.
- Select the variable that you want to filter on by typing its variable name into the “search variables” text bar.
- Filter in the categories/levels within the variable by:
- Categorical: Clicking on the “Search categories”" text bar. Scroll and select the category you want to keep in your data. Repeat this step to add additional categories.
- Continous: Click the “cycle button” found under the variable you have selected. Two new boxes will appear.
- Select the minimum value for your subset data in the box on the left by typin the value.
- Select the maximum value for your subset data in the box on your right by typing the value.
- To add another filter repeat the steps above. A maximum of three filters are recommended to maintain statistical power (added filters reduce sample sizes and reduces statistical power).
- Once selected, the name(s) of the filtered variable(s) will appear to the right of “Filters”.
You are able to filter on all types of variables: required for calculation, recommended for calculation, and all other variables.
4.4.1 Remove a filter
- To remove a filter entirely, click on the trash can beside the variable you want to delete.
- To remove a level within a filtered variable - categorical, click on the ‘x’ beside the variable level.