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
Next: Root
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
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
I'm familiar with the ability to use the Literal operation in the Pivot Table macro in the Table Toolbox.
Is there any equivalent of that literal operation when using the PIVOT function within the SQL section of a Custom Table Transformer macro? Or is it required to use a true (numerical) aggregating operator like MAX, or SUM, etc.?
Hi @Jim Solomon,
The PIVOT function inside the Table Transformer macro doesn’t recognize the LITERAL option but you may use the GROUP BY function instead. Please see an example below:
SELECT 'Person',
FORMATWIKI(SUM('Activity' + "\n")) AS 'Activity',
FORMATWIKI(SUM('Value'::string + "\n")) AS 'Value'
FROM T1
GROUP BY 'Person'
Hope this workaround 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.