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?
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)
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.