Filter Logic
When creating filters for your report you can use the AND, OR and NOT logic operators. Apply customized logic and specify the way of combining filters.
Let us look at the example of customized filter logic.
There are following questions in your survey:
How old are you?
18 and younger
19 to 40
41 to 60
60 and older
Which state do you live in?
You want to see the survey results based on respondents who live in Georgia and who are 19 to 60 years old.
In this case you need to set following filters:
Filter Type: Question
Question: How old are you?
Answer: 19 to 40Filter Type: Question
Question: How old are you?
Answer: 41 to 60Filter Type: Question
Question: Which state do you live in?
Include records: That contain Georgia
In the Filter Logic text field you should enter the following expression:
(F1 OR F2) AND F3
Only filters mentioned in the text field will be used to create the report. In the example above:
If you set customized logic as F2 AND F3, the report will be on respondents who are 41 to 60 years old and who live in Georgia, even if Filter 1 is checked as Active.If you unselect the Active option next to filter involved in customized logic, this filter will not be used in report. In the given example the report will be based on respondents who are from 19 to 40 years old and who live in Georgia.
Once you save customized filter logic, operators will be substituted with respective symbols after saving: || for OR and && for AND