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}

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.