Charting Individual Values from Multi-Select Custom Field

Hi WF Community,

I saw this Community post from 2022, which is now locked, and was wondering if anyone has found a way to accomplish this? 

What I'm Trying to Accomplish

I have a multi-select custom field called "Digital Deliverables" with 8 possible values on my Project reports. I need to create a chart that shows the count of projects containing each individual value, not unique combinations.

Example:

• Project A selected: A, B, F
• Project B selected: A, B, C, D
• Project C selected: A, G, H
• Project D selected: A, G

Desired Chart Output:

• Value A = 4 projects
• Value B = 2 projects
• Value C = 1 project
• Value D = 1 project
• Value F = 1 project
• Value G = 2 projects
• Value H = 1 project

What I've Tried

I followed the Adobe documentation on Chart a Report by a Multi-select Custom Field, which suggests creating a calculated custom field that references the multi-select field using {DE:Digital Deliverables}.

The Problem: This approach groups by the entire combination of selected values, giving me counts like:

• "A, B, F" = 1
• "A, B, C, D" = 1
• "A, G, H" = 1
• "A, G" = 1

This doesn't meet my needs because I need each value counted separately across all projects where it appears.

My Question

Is there a way to accomplish this in Workfront using text mode or any other native reporting functionality?

Thanks!
Nick