Expand my Community achievements bar.

Interested in getting an Adobe Workfront certification? Don't miss our AMA on June 10th, where our experts will be available to answer any questions you may have about getting certified!

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 : )