Grouping by multiselect field in report | Community
Skip to main content
A
Avichal-1
March 14, 2024
Question

Grouping by multiselect field in report

  • March 14, 2024
  • 1 reply
  • 510 views

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

Madalyn_Destafney
Community Advisor
Madalyn_DestafneyCommunity Advisor
Community Advisor
March 14, 2024

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 : )
    Terms & ConditionsAccessibility statement

    Loading footer...