Can you change the sequence of Status columns in a two-dimensional JIRA Chart Macro?

[Tanmay Gadkari]

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'. 

[Katerina Kovriga _Stiltsoft_ · Accepted solution]

Hi @Tanmay Gadkari ,

You may try the Table Filter and Charts for Confluence app and its Table Transformer macro.

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.

[Tanmay Gadkari]

Hi @Katerina Kovriga _Stiltsoft_  

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. :) 

Regards,

Tanmay