Filtering reports

Hi there,

I have a look at some of the answers on here but can't find one applicable to my problem.

The final question in my 15 question survey is a drop down list with 8 options. I want to be able to create two reports, one containing only the answers (for the 14 previous questions) from people who went on to chose options 1-4 and another from people who chose options 5-8. Is this possible?

I've tried to filter the whole survey but it filters people who answered option 1 AND option 2 AND option 3 AND option 4. Given they were only allowed to pick one option, this leaves me with a report with no responses.

I could do easily enough if there was an OR operator...(I also know it would be possible with a differently designed survey that asked are you A or B? and then only displayed the relevant 4 options after but sadly I didn't write the survey, just trying to analyse it...)

Thanks very much in advance

[pwiesner]

Unfortunately the report filter screen only supports the logical AND operator. There is an existing tracker item to add support for the OR operator. Given the constraints of the problem, that a respondent can only select one answer, I believe you can create the appropriate filter by negating your logic. Additionally I have made the assumption that question is required. For example:

(1 OR 2 OR 3 OR 4)

could be rewritten as

(!5 AND !6 AND !7 AND !8... AND !15) Note: ! indicates is not equal to.