Reporting On How Many Times a Multi Select Option is Selected

[IsaacWu]

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? 

[skyehansen]

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.

[IsaacWu]

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]

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

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.

[IsaacWu]

Thanks! It seems like there's no way to chart the Calculated Field Grouping without taking it into Excel and doing something with a comma delimited. Wish that was something these charts could do!