Best way to report the counts of selections from a multi-select field
I’m trying to figure out the best way to report on the counts of selections made on a multi-select field for projects. There is currently a calculated field on the project form to capture choices, but that created entries on the report like “Choice 1, Choice 2”, “Choice 1, Choice 3, Choice 4” etc. Stakeholders are asking to segment them out individually. It sounds like I might have to make individual calculated fields for each of the 15 choices on the multi-select field. Am I on the right path to try and capture this data?