nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to create specific reports in JIRA?

Dawid Poblocki

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

Accepted answers

All comments

Raimonds Simano1

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

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 Simano1

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 Simano1

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.

Nayan

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

Midori

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:

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

shaymandel

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

app

jira-app-development