Create report with all bugs and custom calculated fields?

My goal is to create an excel report that lists all issues where type = bugs, status is not closed or declined that can be emailed on a regular basis (weekly).

 

The report will need a column to give each bug a number based on the custom field of severity (minor = 1, moderate =5 major = 10 etc) and then a final column calculating the total number. Has anyone done anything like this before? What approach did you take? 

Thanks in advance.

4 answers

1 vote

Most of this is easy - define a filter for bugs with status not in (closed, declined).

A download is easy too - click "view in Excel" from the issue navigator.

The next bit needs some code - you'll need to find/write a Connect addon that can do the calculated field for you, OR something that can display the data from the filter in the format you need with the totals field added.

Hi Matthew,

If you are still searching for best solution, please take a look at eazyBI report creation add-on for JIRA. With eazyBI you can create custom reports based on JIRA data. Here is an example report that shows how many issues are created and resolved in each time period and how many remain open by the end of the time period. You can change the Page filter for Issue Type to only see this report about Bugs.

eazyBI reports can be exported to excel or regular report export to PDF can be scheduled. See more details here https://docs.eazybi.com/display/EAZYBI/Create+dashboards#Createdashboards-Dashboardemailsubscription or let me know if you have any additional questions!

Kind regards, 
Lauma / support@eazybi.com 

Matthew, I am happy to hear you are trying eazyBI!

You can select custom fields to be imported as measures in Source data tab / Import (before manual import the import options screen is displayed). If you would import a numeric custom field as measure you would get several new calculated members that would display totals on different dates; you can select them in Measures dimension. See more here https://docs.eazybi.com/display/EAZYBIJIRA/Custom+Fields#CustomFields-Totalsofcustomnumberfields.

By default the JIRA issue custom fields are visible here. I checked your account though and did not see the bugscore custom field. Is it a custom field in JIRA or you would add the score dynamically based on severity? In this case I would suggest to create a JavaScript calculated field in eazyBI, see more details https://docs.eazybi.com/display/EAZYBIJIRA/JavaScript+calculated+custom+fields
This field would not appear in JIRA, but you would be able to select it for import.

Let me know if you would need further assistance with this! In this case let me know also which report you are working on.
Lauma / support@eazybi.com 

Thanks for the replies @Nic Brough [Adaptavist] and @Lauma. 

I have an eazyBI license now and am playing around with that. Is it possible to add custom fields into the excel/pdf exports?

 

Example would be, I want the bugscore field to check the bugseverity and add a number based on that and then I want a total bugscore field to display the sum of all bugscores.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 18, 2018 in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

23,705 views 2 7
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you