How to create specific reports in JIRA?

Dawid Poblocki December 12, 2011

Hi,

Is it possible to create report which show number of created and resolved issues in each month? This report should have configurable custom fields.

Second report which show time spent since issue in a period of time with configurable custom fields and with precentage of all issues?

And third report which show time from creation to resolve issue with configurable time interval and avg. resolution time?

Did You know any plugins which can help me?

Thanks & Regards,
David

3 answers

3 votes
Raimonds Simanovskis
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.
December 12, 2011

eazyBI reporting application has standard JIRA integration - after initial JIRA issues import you will get sample "created vs resolved issues" report. There are "average resolution days" (for resolved issues) and "average age days" (for unresolved issues) measures available that you can use when creating custom reports. As well as "hours spent" measure that you can use to get total time spent on individual issues or summary per selected dimensions.

If you need more help in creating these reports then please contact eazyBI support.

Dawid Poblocki December 13, 2011

Yes I know about created vs resolved issues report but I would to add dependence on custom field (select list), and second custom field (database values selection field).

Raimonds Simanovskis
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.
December 13, 2011

eazyBI provides more advanced creted vs resolved issues report than standard JIRA reporting plugin. Currently you can filter results using default JIRA fields (project, component, version, type, status, priority, reporter, assignee, resolution) but I plan to add support for custom issues fields as well. If you are interested then please try out eazyBI and I would be glad to hear any other feedback from you.

Raimonds Simanovskis
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.
January 1, 2012

Wanted to comment that new version of eazyBI JIRA integration supports import of JIRA issues custom fields as well. Read more in eazyBI JIRA integration help page.

Toni Mofardin August 16, 2012

Is it possible to get a Created vs 'Custom status' chart? I haven't found any plugin that can do that. Or perhaps there is a way to match 'Custom status' with status 'Resolved'?

Raimonds Simanovskis
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.
August 16, 2012

Yes, if you have 'Custom status' custom field then you can import it as additional dimension in eazyBI and you can make 'Created issues' by 'Custom status' reports. You can also combine custom status with standard status dimension.

0 votes
Midori
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.
October 28, 2014

Better Excel Plugin exports JIRA issue data into pre-defined Excel templates. You can define your specific reports in the Excel templates without entering any actual data, and the plugin will fill the cells with the most current data at every export.

For your concrete use cases:

  1. What you describe should be a pivot table.To get your results faster: the plugin includes a default "created vs. resolved" template (see the screenshot), just add your custom fields to those.
  2. I couldn't precisely understand your description, but it suggests you will need a simple table and use Excel formulas (or use Groovy scripts if Excel by itself is not sufficient to your needs).
  3. For the "configurable interval", you may either use a specific JQL query or just dump out every issue and use Excel's filtering feature. Both will work, the question is whether you want to filter in JIRA or in Excel. "Time from creation to resolution" is a dead simple formula in Excel, while "Avg. Resolution Time" can be calculated by applying the AVG() function to the previous column.

Try the Better Excel Plugin!

jira-created-resolved-report.png

0 votes
Nayan February 26, 2014

I can't see the JIRA field Component, whereas I can see the others. Any suggestions?

shaymandel February 7, 2016

I have the same issue - can't find the Component field.

Suggest an answer

Log in or Sign up to answer