I am creating a dashboard for responses to a drinking water survey where people can state the subject(s) of their concern. The 'subject of concern' field is multiple choice; a couple examples of choices are 'leaks' 'appearance' 'taste' 'pressure'. When trying to filter the data, I get these options:
- 'leaks'
- 'leaks appearance'
- 'leaks taste'
- 'leaks taste pressure'
- 'taste'
- 'taste pressure'
- 'appearance pressure'
- 'appearance taste'
- etc.
I want to have a single filter that shows me ALL concerns that list a single choice; as in, I want to have a filter that shows me all concerns with 'leaks' in them, all concerns with 'taste', etc. so I suppose I'm asking if I can group fields together.
Is this possible?
