Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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. 

status_jirachart.png 

Is there any way this can be modified so that the columns appear as 'In Progress, Ready to Accept, Done and Production Released'. 

 

1 answer

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:

Thu 1-1.pngThu 1-2.pngAnd 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*

Thu 1-3.pngAs you can see, the column order has changed:

Thu 1-4.pngHope this helps your case.

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 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Announcing Team Calendars in Confluence Data Center

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

177 views 0 6
Read article

Community Events

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

Events near you