Chart to Table - Multiple Values show as Single value

Charles Middlebrooks February 7, 2024

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?

pie selections.JPGTable selections.JPG

2 answers

1 accepted

0 votes
Answer accepted
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 7, 2024

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 February 7, 2024

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 7, 2024

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.

Like # people like this
Charles Middlebrooks February 7, 2024

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 7, 2024

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 8, 2024

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:

Thu 2-1.png

Internal Table Transformer:

Thu 2-2.png

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

Middle Table Transformer:

Thu 2-3.png

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

External Table Transformer:

Thu 2-4.png

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

Chart from Table:

Thu 2-5.png

And here is your page in a published state:

Thu 2-6.pngHope this helps your case. 

2 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 7, 2024

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.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events