how to get bug count status and priority in jira to excel sheet and create a pivot table

[sunil raghav]

how to get bug count status and priority in jira to excel sheet and create a pivot table like priority status, count date

[Kavitha Chandrasekaran]

hi @sunil raghav 

1) Create a filter for bugs.

2) You can use the inbuilt Jira dashboard to group the bugs by priority using a pie chart.

or

3) If you want to export, you can export from the filter to a csv file. 

4) delete columns not required in the excel (so it is not cluttered), then you can use the pivot table. To create a pivot table, you can see some videos in Excel. 

[Hannes Obweger - JXL for Jira]

Edit: Moved to separate answer.

[Hannes Obweger - JXL for Jira]

Hi @sunil raghav,

welcome to the community!

Just to add to @Kavitha Chandrasekaran's answer: Another direction would be the Atlassian Marketplace. There are tons of great apps available, from small to comprehensive, many of which can help with aggregating issue data.

As an example, my team and I work on an app that allows creating Excel-style pivot directly in Jira, based on live Jira data: JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

With these, you can build a view like the one above in just a couple of clicks:

This is really just one example; you could also group your issues by status, priority and status, or any other (combination of) issue fields.

Any questions just let me know,

Best,
Hannes