AnsweredAssumed Answered

How can I generate reports off a Multiselect field that has several values in it?

Question asked by Shafique Kassam on Dec 9, 2016

How can I report on a multiselect field? It has options like several occupations: Doctor, Student, Nurse, Retiree, SelfEmployed, etc.

 

I want to run a report that shows me the counts of all the professions. If I do a filter query that says "Occupation IS Doctor" OR "Occupation IS Student" OR "Occupation IS Retiree" OR "Occupation IS SelfEmployed", then I only get those values that are single selections.

 

If a record has "Doctor" and "Student" selected, then it is not included in this filter.

 

I tried to use the "IS ONE OF" query, but now I get results like:

 

Doctor: 50

Student: 30

Doctor,Student: 10

 

How can I get a report to show me that there are 60 Doctors and 40 Students, instead of the breakdown above?

Outcomes