<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Creating a Chart for a Multi-Select Custom Field in Workfront Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/creating-a-chart-for-a-multi-select-custom-field/m-p/507161#M38911</link>
    <description>&lt;P&gt;I also need this in 1 chart. Thanks.&lt;/P&gt;</description>
    <pubDate>Fri, 17 Jun 2022 21:01:14 GMT</pubDate>
    <dc:creator>BenettaPe</dc:creator>
    <dc:date>2022-06-17T21:01:14Z</dc:date>
    <item>
      <title>Creating a Chart for a Multi-Select Custom Field</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/creating-a-chart-for-a-multi-select-custom-field/m-p/507158#M38908</link>
      <description>&lt;P&gt;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. &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;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:&lt;/P&gt;&lt;UL&gt;&lt;LI&gt;Where we would like to see individual pie pieces for: &lt;UL&gt;&lt;LI&gt;Accountant - 3&lt;/LI&gt;&lt;LI&gt;Broker - 2&lt;/LI&gt;&lt;LI&gt;Partner - 1 &lt;/LI&gt;&lt;LI&gt;Prospect - 4&lt;/LI&gt;&lt;/UL&gt;&lt;/LI&gt;&lt;LI&gt; We are actually seeing pie pieces for:&lt;UL&gt;&lt;LI&gt;Accountant, Prospect - 1 &lt;/LI&gt;&lt;LI&gt;Broker, Prospect - 1 &lt;/LI&gt;&lt;LI&gt;Accountant, Broker, Prospect - 1 &lt;/LI&gt;&lt;LI&gt;Accountant, Partner, Prospect - 1 &lt;/LI&gt;&lt;/UL&gt;&lt;/LI&gt;&lt;/UL&gt;&lt;P&gt;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?&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;@Josh Blackwood‚ &lt;/P&gt;</description>
      <pubDate>Mon, 22 Mar 2021 16:25:10 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/creating-a-chart-for-a-multi-select-custom-field/m-p/507158#M38908</guid>
      <dc:creator>JessicaRy</dc:creator>
      <dc:date>2021-03-22T16:25:10Z</dc:date>
    </item>
    <item>
      <title>Re: Creating a Chart for a Multi-Select Custom Field</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/creating-a-chart-for-a-multi-select-custom-field/m-p/507159#M38909</link>
      <description>&lt;P&gt;Hi Jessica,&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;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.&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;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).&lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;Regards,&lt;/P&gt;&lt;P&gt;Doug&lt;/P&gt;</description>
      <pubDate>Mon, 22 Mar 2021 18:38:12 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/creating-a-chart-for-a-multi-select-custom-field/m-p/507159#M38909</guid>
      <dc:creator>Doug_Den_Hoed__AtAppStore</dc:creator>
      <dc:date>2021-03-22T18:38:12Z</dc:date>
    </item>
    <item>
      <title>Re: Creating a Chart for a Multi-Select Custom Field</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/creating-a-chart-for-a-multi-select-custom-field/m-p/507160#M38910</link>
      <description>&lt;P&gt;Hi, &lt;/P&gt;&lt;P&gt; &lt;/P&gt;&lt;P&gt;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. &lt;/P&gt;</description>
      <pubDate>Fri, 01 Apr 2022 14:57:27 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/creating-a-chart-for-a-multi-select-custom-field/m-p/507160#M38910</guid>
      <dc:creator>NiteshD_</dc:creator>
      <dc:date>2022-04-01T14:57:27Z</dc:date>
    </item>
    <item>
      <title>Re: Creating a Chart for a Multi-Select Custom Field</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/creating-a-chart-for-a-multi-select-custom-field/m-p/507161#M38911</link>
      <description>&lt;P&gt;I also need this in 1 chart. Thanks.&lt;/P&gt;</description>
      <pubDate>Fri, 17 Jun 2022 21:01:14 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/workfront-questions/creating-a-chart-for-a-multi-select-custom-field/m-p/507161#M38911</guid>
      <dc:creator>BenettaPe</dc:creator>
      <dc:date>2022-06-17T21:01:14Z</dc:date>
    </item>
  </channel>
</rss>

