Charting Individual Values from Multi-Select Custom Field

[NickVa9]

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

[skyehansen]

no there's not. I do recall that I had a chat with the PM over Canvas dashboards asking if he would consider adding this to his roadmap but didn't hear back.

[Madalyn_Destafney · Accepted solution]

@mattmitchell will Canvas be able to help us here? I was also trying to make a chart report in Canvas this week with a multi-select field and not having success, I thought this could be accomplished in Canvas...

[Doug_Den_Hoed__AtAppStore]

Hi @NickVa9,

Natively, I do know of one way, but it is complicated and fragile, so would not recommend it.

Regards,

Doug