Expand my Community achievements bar.

Don’t miss the Workfront AMA: System Smarts & Strategic Starts! Ask your questions about keeping Workfront running smoothly, planning enhancements, reporting, or adoption, and get practical insights from Adobe experts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Creating a Chart for a Multi-Select Custom Field

Avatar

Level 1

Using the "Group and chart a report by a multi-select custom field," knowledge article, I created a chart using a calculated field that points to a multi-select custom field.

Instead of the pie chart containing a pie piece for each individual value contained in the multi-select field, the pie pieces contain combinations of values from the field. For example:

  • Where we would like to see individual pie pieces for:
    • Accountant - 3
    • Broker - 2
    • Partner - 1
    • Prospect - 4
  • We are actually seeing pie pieces for:
    • Accountant, Prospect - 1
    • Broker, Prospect - 1
    • Accountant, Broker, Prospect - 1
    • Accountant, Partner, Prospect - 1

Has anyone attempted this before? Did I not follow the instructions correctly - or is there another way to produce the intended result of displaying a single pie piece for each unique value in the multi-select custom field?

@Josh Blackwood‚

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

3 Replies

Avatar

Community Advisor

Hi Jessica,

Each data row behind a pie chart can belong to only one slice, which I suspect explains what you are actually seeing: 4 rows across 4 unique combinations of the Multi Select values.

To get what you would like to see, one approach would be to instead create a separate chart for each unique multi-select value (e.g. Accountant Chart) and filter for the related multi-select condition of interest (e.g. "Accountant" selected), to then return all of the rows that match (e.g. 3).

Regards,

Doug

Avatar

Level 1

Hi,

I have the exact same problem, the separate chart idea works, but has anyone found a workaround for this solution to display the data in a single chart ? its a much nicer experience.

Avatar

Level 10

I also need this in 1 chart. Thanks.