Wrap your Jira Issues into the Table Transformer macro body and use a custom SQL preset to create a new column with conditional statuses:
WHEN T1.'P' LIKE "Major"
END AS 'Priority New'
Here I used only one priority type cause it's an example but you should list all of them and choose any lozenge colors and names as you need.
If you don't need the old 'P' column and/or want to change the columns' order, just list the required column names after the SELECT instead of the *: SELECT T1.'Key', T1.'Created', etc.
Hope this helps your case.
Hi Atlassian Community, Remote work has shifted how teams collaborate, and we’ve heard from many of you that Microsoft Teams has become mission critical to many of your workflows, from how you chat...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events