Chart to Table - Multiple Values show as Single value

[Charles Middlebrooks]

When I create a pie chart or table using a field with multiple select or one that can contain multiple values (like labels, components, etc), Chart from Table treats these as a single value rather than multiple instances of the value.

Is there a way (maybe with Table transformer) to somehow get Jira to understand a single issue with multiple selections to treat each selection individually?

[Nic Brough -Adaptavist- · Accepted solution]

Welcome to the Atlassian Community!

That is because they are separate individual values.

I think you could use the table transformer to do it, but only by telling it that the select value options are all single selects, not separate values (For example, "red, blue" would not be counted as "red" or "blue", and is different to "red, blue, green" as well)

[Charles Middlebrooks]

Yeah I want "Connection Crashing" for example, to be treated as one count of Connection and one count of Crashing. Not one count of Connection Crashing

[Stiltsoft support]

Please look into the cell value delimiter option of the Pivot Table macro: https://docs.stiltsoft.com/tfac/cloud/managing-pivot-table-options-42239653.html#Managingpivottableoptions-Setthecellvaluedelimiter

It may help to count your values separately.

[Charles Middlebrooks]

Yes, I think this is probably what im looking for! Any idea what the Unicode charater im looking for is? looking at the list in https://en.wikipedia.org/wiki/List_of_Unicode_characters, "Bullet" shows as U+2022 but that doesnt seem to impact my counts. Neither does "Space", or a variety of new line characters.

[Stiltsoft support]

The bullet point won't be visible for the macro: it is not a real symbol but html character. To separate entries, you should use commas or, for example, semicolons at the end of each option.

There may be a workaround with the Table Transformer macro, please see the next reply for the details.

But again it is always better to use visible real characters as separators.

[Stiltsoft support]

Hi @Charles Middlebrooks ,

We've returned to your case: the mentioned workaround behaves inconsistently in the view mode so I've removed the screenshots.

Please follow this example:

Internal Table Transformer:

SELECT *,
T1.'Type'->tfView AS 'Type'
FROM T*

Middle Table Transformer:

SEARCH / AS @a EX('Type'->split("</li><li>")) /
RETURN(@a->'Project' AS 'Project', _ AS 'Type', @a->'Number' AS 'Number') FROM T*

External Table Transformer:

SELECT *,
HTML_DECODE('Type'::string) AS 'Type'
FROM T*

Chart from Table:

And here is your page in a published state:

Hope this helps your case. 

[Stiltsoft support]

Hi @Charles Middlebrooks ,

Not sure what you are trying to count here - if I understand correctly, you are trying to create a chart based on the Pivot Table macro.

Maybe you should reorganize your pivot table (make it one dimensional)?

You may share the screenshot of your source table and describe what exactly should be counted.