We are building a dashboard in Confluence which is pulling data from one of our JIRA projects. The query in the JIRA Chart macro works fine. We have Epics configured on the Y Axis and Status on the X-Axis in the two dimensional chart. However, the sequence of how the statuses appear is not accurately representing the flow of the stories.
Screenshot shows what we are rendering right now. Numbers in red on top of each status represent the actual sequence of how the columns should appear.
Is there any way this can be modified so that the columns appear as 'In Progress, Ready to Accept, Done and Production Released'.
Hi @Tanmay Gadkari ,
Wrap your Jira Charts macro in the Table Transformer macro:
And list the columns as you need with the help of a custom SQL query.
For example, I've used the following query: SELECT T1.'Assignee', T1.'Status To Do', T1.'Status In Progress', T1.'Status Done', T1.'Status T:' FROM T*
As you can see, the column order has changed:
Hope this helps your case.
Thanks for the prompt reply! Appreciate the help.
Yes, this seems like a great solution that will meet my exact requirement. Unfortunately, the JIRA and Confluence deployment is controlled at the enterprise level (typical large org setup) and we do not have the liberty to install additional plugins in any form or capacity.
I will explore this with the Atlassian tool-stack team and see if it can be implemented. If there are any other workarounds without an additional plugin, inputs around that will also be appreciated.
Thank you once again for the detailed response with the examples. :)
Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond. A long time favorite, Team Cale...
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