How to re-arrange columns on 'Two-dimensional filter statistics' table in dashboard?

[Saad Ahmad]

Hi, i need help in re-arranging columns on a 'two-dimensional filter statistics' table.

I want to show epics in different statuses w.r.t. different business units. 

I created a filter, see below, and selected the statuses in a logical sequence

On a dashboard, I added a 'Two-Dimensional filter statistics' table and linked this filter with it. upon saving, I'm getting the required results but I'm unable to re-arrange the table columns. i want to re-arrange the statuses in sequential order. 

[Jack Brickey]

Hi @Saad Ahmad , sadly you cannot configure the column order in this gadget.

[Saad Ahmad]

Ah! is there a free alternate? or any other solution?

[Jack Brickey]

I am unsure of any free alternative, but there are certainly paid apps to choose from. You could consider exporting to excel but that take you outside of the Jira environment. You might consider searching the community for similar questions and answers. I know this has come up a number of times throughout the years. I truly do wish that Atlassian would implement something for this.

note: I just check JAC and did not immediately find an open suggestion which is surprising.

[Bill Sheboy]

Hi @Saad Ahmad and @Jack Brickey 

I found several open suggestions related to changing / consolidating the column sort order, including by workflow:

Allow for customizing 'Two dimensional filter' column order

Two Dimensional Filter Statistics gadget should allow sorting of values as configured in select list custom field

Two Dimensional Filter Statistics - Ability to sort by the workflow status natural order

Two Dimensional Filter Statistics + Time in Status gadgets repeatedly returning same statuses from Team-managed projects

As most have been open for many years, checking the marketplace for a replacement seems like a good idea.

Kind regards,
Bill

[Ray Shalabi]

See this article with a solution that is described as applying to Server or Data Center, however I tested it in Cloud and it also worked there.

Jira - How to change the order of the statuses in a Two Dimensional Filter Statistics gadget | Jira and Jira Service Management | Atlassian Support

You're not modifying the Two-dimensional table gadget directly.  Instead, you're making a site-wide change to the order of Statuses, which will then be reflected in the column order in the Gadget in the Dashboard.  My only concern is that if I change the Order of the Statuses at the site level, it may impact the way data is displayed in other places in Jira.

Regards,

Ray

[Kh_Safal]

@Ray Shalabi, this topic has been locked because the thread has become a bit dated. If you’d like to keep the conversation going or have additional questions, we encourage you to start a new topic. You can read more about necro posting (“raising threads from the dead”) in our Community Guidelines.
Thanks!