How to generate the report of number of issues at the particular status in Jira software?

Venkat Jira Admin April 4, 2024

In Jira software, how to generate the report of number of issues at the particular status (Open and closed) in Excel format?

4 answers

1 vote
Danut M _StonikByte_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 16, 2024

Hi @Venkat Jira Admin,

If you have our Great Gadgets app installed, you can easily do this by using the Pivot Table & Pivot Chart gadget.

image.png

Hope this helps. 

Danut.

1 vote
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 5, 2024

As the easiest thing to do, just use the Better Excel Exporter app to export your issues with a few clicks (make sure that the "key" and "status" fields are exported!), then create a pivot table in Excel, from "count of key" and "status".

It is totally trivial!

Or, as an advanced solution, if you want to create a custom template for this, then you can create an Excel export template that will show the pivot table immediately after exporting. It takes a little longer, but if you have to produce this report repeatedly, then it may worth the extra work!

For example here is a template that shows the pivot table for "time in status" values (which is a more complex problem than yours):

jira-workflow-report-pivot-table.png

(Discl. it is a paid and supported app developed by our team. Free for 10 users!)

1 vote
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 4, 2024

Hi Venkat,

Create a Filter for the issues you want to see in general. Like Project =  ABC. Or you can use an existing filter used by a Jira Software board.

Then you can Create a Dashboard and add an Issue Statistics gadget to the dashboard. Use the filter above.  Make the Status field the Issue Statistic.

It will then show you the number of issues in each status as a count. You can click on the count/number to see the actual list of issues. 

Venkat Jira Admin April 5, 2024

Hi @John Funk 

Thanks for the reply,

I have created the dashboard, but I want to download that report in Excel or CSV format.

John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
April 5, 2024

What specifically do you want to Download? Every list by Status? If so, you can click on the count for that status and then when you get to the list of issues, you can click on the Export button there to export them. 

0 votes
Venkat Jira Admin April 17, 2024

Hi all, 

Thanks for the reply.

I have used Reports - Charts and Graphs for Jira Dashboard Free for downloading the Excel Report of requests Status wise (Open (Open, in progress, implementation), Closed (Closed)), and any field wise.

Suggest an answer

Log in or Sign up to answer