SurveyMonkey.com - The best thing since the opposable thumb!Help Center
Can I Apply Multiple Filters?
 a_Filter Responses.gif
You may apply only one saved Filter set to your results.
We offer three different filter types that you can combine for a single Filter set. Plus, the Properties filter type allows multiple filter components as explained below.
 
To Apply Filters to Your Results:
Click the [Filter Responses] button

arrow.gif Step-by-step example

Select the type of filter(s) to apply: Responses, Properties, and/or Collector(s). After you've configured your filters, click the [Save All Filters] button at the top of the page to save your filter sets and apply them to your results.

a_Save Filter Settings.gif

 Available Filter Types:
  1. Responses - How a respondent answered a specific question.
  2. Properties - The date the survey was started for example.
  3. Collector   – Show responses received by a specific Collector.
   
1.

 Filtering By Responses

 
 

Filtering by Responses enables you to filter your results based on specific responses to questions. You can add multiple filters and combine them with a logical expression. After you have applied the filter to your results, you may then export your results with the filter applied to open an export containing only your filtered results.
 
To Filter by Responses:
  1. Click the Filter By Responses option
  2. Click [Add New Response Filter]
  3. Select the question from the drop-down menu to which you will apply the logic.
  4. Select the parameters or answer choices for the filter from the second drop-down menu.

Click the [New Response Filter] button to add another filter by response. After adding a second filter, you can then use the and/or logic to "match" multiple filters or create your own custom combination of filters.

How should the filters above be combined?
  every filter must match ("and" logic)And logic matches ALL filters
 logicbtn any filter can match ("or" logic)Or logic matches ANY of the filters
 logicbtn custom combination of filtersSee examples below
See: How do I create multiple filters? for more responses filters examples.
 
Note: To save your filter settings, click [Save All Filters]. arrow.gif Click for step-by-step example

How to Create Custom Combination of Responses Filters

 
We cannot provide support for custom filters, but here's how it works. 
Note: Each filter is signified by [Filter1], [Filter2],...[FilterN]  
Note: You may use: AND, OR, and NOT to combine filters 
Note: Use parentheses to make your logic unambiguous: ([Filter1] OR [Filter2]) AND ([Filter1] OR [Filter3] 
Examples:
English:  Show me all respondents who match [Filter1], and who do not match [Filter2] or [Filter3].
Logic:  [Filter1] AND NOT ([Filter2] OR [Filter3])
English:  Show me all respondents who match [Filter1] and [Filter2], or who match [Filter1] and [Filter3].
Logic:  ([Filter1] AND [Filter2]) OR ([Filter1] AND [Filter3])
Don't add spacing between the brackets. Example formats with spacing: [ Filter 1 ] or [Filter 1]  - The system cannot recognize that you are referencing a filter if you add any spaces between the brackets.
 Tip:  Correct format: [Filter1] AND [Filter2]
  Star Advanced filter or custom combination of filters example at bottom of the page. 
 

2.

 Filtering By Properties

 
 

Filter by Properties

To add a filter based on specific properties, click the Filter by Properties option. Filtering by Properties allows you to filter your results by:
  • Response Dates
  • Response Modified
  • Response Time
  • Response Status
  • Respondent type
  • Email Address Star
  • First name Star
  • Last name Star
  • Custom values, or
  • IP Address
  StarAvailable only when using the Email Invitation Collector

For example, if you would like to display only completed survey results, select Filter by Properties under [Filter Responses] and select "Responded Completely Only" from the Response Status option and save the Filter.  When you apply this filter, your Filtered results or Filtered Total will then display only the surveys that have been completed.

Note: The partial response option is determined by clicking the Submit button for the survey. If that button has been clicked, the response is completed regardless of the actual number of answer selections made.
Note: Filtering by date includes an implied time of 12 AM for each entered date. That means to filter for a specific date, you would need to filter for that date and the the day after to include what is considered the enter day. The same is true when you try to filter for a month. To filter for the month of September, for example, you would set the filter between 9/1/08 and 10/1/08. To filter for September 12th: enter response started between 09/12 and 09/13.
   

3.

 Filtering By Collector

 
 

a_Filter By Collector.gif

 

Click the Filter By Collector option to filter by specific collectors. Clicking the link will open a list of your current collectors for the survey.  Select the collectors you want to include in the results analysis. Once you have selected the collectors to filter by, click [Save All Filters].

Tip:Selecting to filter by a Collector(s) displays only the results collected by the specified Collector(s). You cannot filter by Collector if you have only one Collector collecting responses.

After you've selected the filters to apply to your results, click the [Save All Filters] button at the top of the page to save your filters and apply them to your results. Click to see how to apply set Filter when Exporting

 Warning:Editing a question in any way after a filter has been applied deletes the filter details. If this happens, the filter name is listed, but the filter details are removed because the system cannot incorporate any changes you make to questions into current filters.
 

Common Questions Common Questions

Question

I am analyzing the results of a survey conducted for a large multinational, with North America locations in Canada and the US. Both Canada and the US have multiple locations.I am attempting to use the filter functions to find, for example, the overall results in Canada. This filtering attempt was successful and returned the correct number of responses for Canada -- 281.

However, when I add an additional filter to the list of seven locations in Canada -- seeking to filter for individual contributors at locations in Canada -- I return with a total of 592 responses.

The filter presumably should give me a subset of the 281, since there are managers, directors and so forth whose replies should be filtered out. The 592 responses include people from US sites, whose responses should have been filtered out. 

 Support Answer

To filter for all responses for Canada, you would need to create 8 filters: 

7 for the locations: ([Filter1] - [Filter7])

1 for the type of the individual: [Filter8] 

Then change the option to “custom combination of filters” and then use the Boolean logic to “OR” all the locations and then “AND” the individual. 

Here is how this custom logic would  look: 

([Filter1] or [Filter2] or [Filter3] or [Filter4] or [Filter5] or [Filter6] or [Filter7]) and [Filter8]

This creates a filter that matches any of the first 7 filters with the 8th filter. So, all respondents that selected location 1 or Filter1 and Filter8 will be shown, and all respondents that selected Filter2 and Filter8 will be shown and so on.

Use of parentheses

While any number of logical ANDs (or any number of logical ORs) may be chained together without ambiguity, the combination of ANDs and ORs and NOTs can lead to ambiguous cases. In such cases, parentheses may be used to clarify the order of operations. As always, the operations within the innermost pair is performed first, followed by the next pair out, etc., until all operations within parentheses have been completed. Then any operations outside the parentheses are performed.

(We cannot provide support to create custom filters.)

  • Each filter is signified by [Filter1], [Filter2],...[FilterN] 
  • The following predicates can be used: AND, OR, and NOT 
  • Use parentheses to make your logic unambiguous: ([Filter1] OR [Filter2]) AND ([Filter1] OR [Filter3]
Don't add spacing between the brackets. Example formats with spacing: [ Filter 1 ] or [Filter 1]  - The system cannot recognize that you are referencing a filter if you add any spaces between the brackets.
 Tip:  Correct format: [Filter1] AND [Filter2]