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.
Hi all!
I manage a program that uses tickets. My page currently has full data table displaying information about all tickets in the program with a pivot table that summarizes all tickets by status. The Table Filter macro will filter both pivot table and data table.
I would like to sort the pivot in an order defined by me rather than alphabetically. I tried to use Table Transformer with SQL query that does this (WHEN T1.'Status' LIKE "Escalation Review" THEN "1"...) but I think the Table Transformer is attempting to sort the data table and not the pivot table.
Is there a way for me to use Table Transformer to apply only to pivot table? Or another macro to use?
Hello @Kelsey Lubbe
Please try this SQL query:
SELECT *
FROM T*
ORDER BY
CASE
WHEN T1.'Status' LIKE "Escalation Review" THEN 1
WHEN T1.'Status' LIKE "Root Cause Analysis" THEN 2
WHEN T1.'Status' LIKE "Corrective Action Plan" THEN 3
WHEN T1.'Status' LIKE "Pending Approval" THEN 4
ELSE 5
END
Katerina
Stiltsoft
Thanks, @Katerina Rudkovskaya _Stiltsoft_ . This is similar to the output I got previously. Screenshot here compared to output without Table Transformer.
No Table Transformer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Kelsey Lubbe ,
Note that in your case, you can change the order of columns just choosing them with the help of autocompletion in Table Transformer according to your needs.
Please see my exampe below:
Use autocompletion: start typing, e.g., T1. and choose the column.
Katerina
Stiltsoft
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Katerina,
Thank you! That did sort the top pivot table in the appropriate order.
Is it expected that the full data table (from Table from CSV in original screenshot) is hidden? The reason why I have the Pivot Table and data table nested inside the Table Transformer macro is because I want the Table Filter macro to apply to both Pivot Table and data table.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Kelsey Lubbe,
You can set it to show or hide the source table in both Pivot Table and Table Transformer macros.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Oh my, I was expecting a checkbox to display/hide and did not expect a dropdown option. My bad on missing that! Thanks so much for the help @Andrey Khaneev _StiltSoft_ @Katerina Rudkovskaya _Stiltsoft_ !
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Andrey Khaneev _StiltSoft_ I think I discovered an issue that simply needs some error handling. It looks like if any of the defined columns does not have a task of that status (meaning count 0), it throws an error and the whole table will not display:
Error: Column does not exist: Count STATUSNAME
Does anyone have a recommendation on how to handle that scenario? I have removed the column with a 0 count and the table displays correctly again. However, we would like to display that column count when it does have tasks in that status...
Thanks so much, the above info has been great in getting us this far!
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.
I think I discovered an issue that simply needs some error handling. It looks like if any of the defined columns does not have a task of that status (meaning count 0), it throws an error and the whole table will not display:
Error: Column does not exist: Count STATUSNAME
Does anyone have a recommendation on how to handle that scenario? I have removed the column with a 0 count and the table displays correctly again. However, we would like to display that column count when it does have tasks in that status...
Thanks so much, the above info has been great in getting us this far!
Added to reply section. Please disregard this.
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.