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

[Venkat Jira Admin]

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

[Venkat Jira Admin · Accepted solution]

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.

[Danut M _StonikByte_]

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.

Hope this helps. 

Danut.

[Aron Gombas _Midori_]

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):

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

[John Funk]

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]

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]

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.