Reporting On How Many Times a Multi Select Option is Selected | Community
Skip to main content
I
IsaacWu
Level 2
June 11, 2025
Question

Reporting On How Many Times a Multi Select Option is Selected

  • June 11, 2025
  • 1 reply
  • 539 views

Hello,

 

I'm trying to run a report on how often a choice is selected on a custom form. I think there are two pieces I need help with: 

  1. The calculated field I'm using to try to 'count' the choices
  2. The report grouping and chart I'm trying to make 

Custom Form

I have a Checkbox field type, any user can select as many options that apply:

I've added a calculated field with the following formula:

{DE: Defect Reasons}

Which now tells me what options have been selected:

Report

The goal of my report is to inform me how many times a checkbox option is selected, but for some reason, I can only use the Grouping 'Task > Calculated Defect Reasons'

 

This is causing the chart to count the full string of choices, rather than the individual choice. Not the most helpful when there are many tasks put into the report:

 

Is there any way to make a calculation that does individual counts of choices? And how could that translate into a Report chart? 

    1 reply

    skyehansen
    Community Advisor
    skyehansenCommunity Advisor
    June 11, 2025

    You can make a set of calculations that does individual counts (i.e. 10 calculations). In terms of charts -- since you only have 10 choices, this would translate into 10 charts or taking it out of workfront to make one chart via excel or powerBI, or whatever tools you have available.

      I
      IsaacWuAuthor
      Level 2
      June 11, 2025

      I'm trying to add an individual calculation to provide me with a value based on if the calculated field contains specific keywords, but I'm having trouble finding where it's going wrong: 

       

      skyehansen
      Community Advisor
      skyehansenCommunity Advisor
      June 11, 2025

      According to the calculated data expressions page
      https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/calculated-custom-data/calculated-data-expressions

       

      Your IF syntax should be: 

      IF(condition, trueExpression, falseExpression)

      and your CONTAINS syntax should be:

      CONTAINS(findText, withinText)

       

      So in other words, syntax should look more like this:

      IF(CONTAINS(findText, withinText), trueExpression, falseExpression)

       

      I see you're missing a closing parens around your contains statement, and a missing comma as well. You also have an additional paren at the end of your IF statement.

        Terms & ConditionsAccessibility statement

        Loading footer...