Reporting on multiselect dropdown field | Community
Skip to main content
S
Sara54
Level 2
February 16, 2026
Question

Reporting on multiselect dropdown field

  • February 16, 2026
  • 1 reply
  • 20 views

Hi everyone,

we have a client who wants a pie chart showing the breakdown of projects by one single-select field and multi-select dropdown field. Single-select field is straightforward. However, a multiselect field is a challenege as I can't use it for grouping in the chart.

Has anyone dealt with a situation where a client wants to display report data based on a multiselect field?

Your inputs are much appreciated!

Best,
Sara

1 reply

VicSellers
Community Advisor
VicSellersCommunity Advisor
Community Advisor
February 17, 2026

Hi ​@Sara54 - I’ve never been able to get a multi-select field into something that would mimic a single-select field in a chart. What have I done though is create calculated fields for all of the dropdown values (if it isn’t too extensive) that count the value. From there I make a table of the number of times the value pops up. I then take it into Excel for a graphic. Not sure that helps, but figured I’d mention it!

 

SUM(IF(CONTAINS("Value",{DE:Multi-Select Field Name}),1,0))

    KatherineLa
    Community Advisor
    KatherineLaCommunity Advisor
    Community Advisor
    February 17, 2026

    For a chart, ​@VicSellers answer is your only option. You have to create a field that simply concatenates the multiple selections into a single field. 

    This link has more info on how to do grouping/charting for multi-selects. https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/custom-view-samples/grouping-by-multi-select-custom-field

     

    In general, this is why I tend to push my users away from creating multi-selects up-front unless they acknowledge directly that I’m not going to be able to easily help them later if their boss wants pretty reports and graphs. 

      Terms & ConditionsAccessibility statement

      Loading footer...