Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to show the total column as second column in Two Dimensional Filter statistics

DEVENDRA
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 4, 2019

Hi All,

I have a requirement to show total all status against each issue type in two dimensional filter statistics report in JIRA

Present order in the report

Issue Type --> New --> In Progress --> Resolved --> Closed --> Total

Requirement

Issue Type --> Total --> New --> In Progress --> Resolved --> Closed

 

is this possible?

Thank you

Kind Regards

Devendra

 

3 answers

0 votes
Olga Videc
Community Champion
June 4, 2019

Hello, 

As far as I know, that's not possible with Jira's default set of reporting tools, you'll need to use some third party app like

Better pdf exporter for Jira

Better excel exporter for Jira

Xcharts

EazyBI

Or you can filter the desired issues, export them to CSV and edit the report manually.

BR, Olga

0 votes
DEVENDRA
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
June 4, 2019

Hi Olga Videc,

Thank you for your response. But I have already done whatever you mentioned in your post. The total (T:) column is coming at the end of all columns (Last Column). My requirement is to display the total column as second column in the output. 

Can you please let me know if we can move the Total column?

 

Thanks

Devendra

0 votes
Olga Videc
Community Champion
June 4, 2019

Adding the Two Dimensional Filter Statistics gadget to your Dashboard

  1. Go to your JIRA Dashboardand click 'Add Gadget'.
  2. The 'Gadget Directory' will appear. Locate the 'Two Dimensional Filter Statistics' gadget and click the 'Add it Now' button. Then click the 'Finished' button at the bottom of the Gadget Directory.
  3. The Two Dimensional Filter Statistics gadget will appear on your dashboard as follows, ready for you to configure:

 

2 dimension filter.png

 

  1. 'Saved Filter start typing the name of the filter, or click the 'Advanced Search' link to search for a filter/select one of your favourite filters/select a filter that you have created.
  2. 'X Axis select an issue field on which the X-axis will be based.
  3. 'Y Axis select an issue field on which the Y-axis will be based.
  4. 'Sort By select how to sort the values of your selected field:

    • 'Natural' — this will use the field's native sorting order, e.g. for the "Assignee" field, the assignee names would be sorted alphabetically.
    • 'Total' — this will sort by the number of issues that match each value, e.g. for the "Assignee" field, the assignee names would be sorted by the number of issues assigned to each person.
  5. Sort Direction select whether the field values should be sorted in Ascendingor Descending
  6. Number of Results type the maximum number of rows that you want the gadget to display per page
  7. Refresh Interval select if you want the gadget to update automatically.

Click the 'Save' button.

If choosing a custom field, please note that the following types of custom fields are supported by this gadget out-of-the-box: 'Group picker', 'Multi select', 'User picker', 'Select list' and 'Version picker'.

Suggest an answer

Log in or Sign up to answer