You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I have a JIRA table of issues that each contain a group of labels. I need to be able to analyze the labels independently, thus have them separated into separate columns.
The string of labels appears in confluence as one long string with spaces between each label such as "Label1 label2 label3"
Any idea how to do this using table transformer? or another method?
Hello, @Craig Alterman
This is Nikita from Stiltsoft.
You can swiftly split the values with Table Transformer without any additional macro or out-of-Confluence steps and then proceed with the values analytics. Here you can see how it it's done.
Additionally, you can resort to Pivot Table usage to splilt values and aggregate right away by configuring cell value delimiter setting in the macro browser.
In case you will need additional help, you can always contact us via a support ticket.
@Craig Alterman were you able to get this resolved? I am looking at something similar but not got results. split() doesnt seem to be working. The link above seems to be adding another row for each label which will not work for my case.
@Katerina Kovriga _Stiltsoft_ any other alternate or suggestions?
Hi @Shikha Saka ,
Unfortunately, there is nothing new from our side: as Nikita has mentioned before, you may split labels by spaces and place every separate label in a separate row (it can be later useful for filtering by every particular label and not the whole string) or set the corresponding value delimiter to aggregate/count each label separately through the Pivot Table macro.