Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

Grouping by multiselect field in report

Avatar

Level 1

I want to get count how many time a value in multi select dropdown is used within the report. Could you please suggest me a way to do this.

 

Or 

How could I seperate selected value in multi select dropdown.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Community Advisor

Hello, you cannot group a report by a multi-select field's value natively. You can create a calculated custom form field that references the values of your multi-select field, and use that calculated field as what you group by. But, just know that any combination of answers will show as their own grouping (i.e. A/B/C is a grouping, A/C is a grouping, B/C is a grouping, etc. See more in the replies on this thread to look at this more in depth.

If you're looking to just pull objects that include a specific value of a multi-select field, you can use that specifically in your report filter, not a grouping...

If this helped you, please mark correct to help others : )