Retrospective reporting

Question

Hi, our team uses Jira to manage emails for 3 separate sections/projects within our department as a to comparison of workloads across these sections.

Today my manager has asked me to run a Average Age and Created vs Resolved report on tickets from each of these sections/projects, to compare data from a date range at the same time last year to same date range this year.  For example, I ran both of these reports this morning 25/8/2021 for the last 30 days. I want to be able to go back to 25/8/2020 and run a report for 30 days.

Can I retrospectively report on these 2 types of reports? I couldn't see anywhere where i could enter the date range for the report. I thought I may be able to enter 365 days to run a 30 day report from 25/8/2020, but it only allows 300 days maximum. My Manager requires number of tickets, average age of the ticket & unresolved issues for comparison.

Any help greatly appreciated.

Thanks, Wendy

Yuliia_Borivets__SaaSJet_ · Answer

Hi @wendy.gniel

You can also check out Time in Status for Jira Cloud. It's a top-rated time monitoring app developed by my team. Here you can choose any date range for created and resolved issues.

Let me know if you need more info.

Ilze Leite-Apine - eazyBI · Answer

Hi @wendy.gniel

Traveling in time in reports is possible using reporting and charts app eazyBI for Jira.

In the report builder, there is a standard option to display value for the same metric from past time periods.

There are some example reports for Average Age and Created vs Resolved issues.

1. Created vs Resolved report that shows, over time, issues created, resolved, average resolution times.

2. Open issue average age in the time shows the average age of issues that were open at the end of each time period.

Both those reports can be modified to show the value for the same period a year ago, for example:

Also, you can always select any other time period to be displayed in the report.

If you have any questions regarding those reports, do not hesitate to contact support@eazybi.com

Ilze, eazyBI Customer Support Consultant

Emre Toptancı [OBSS] · Answer

Hello @wendy.gniel

In case you are OK with using a marketplace app, our team at OBSS built Time in Status app for this exact need. It is available for Jira Server, Cloud, and Data Center.

Time in Status allows you to see how much time each issue spent on each status or assigned to each assignee. You can also combine statuses into consolidated columns to see metrics like Ticket Age, Resolution Time, Cycle Time, or Lead Time.

You can calculate averages and sums of those durations grouped by the issue fields or time segments (For example, see the total InProgress time per Epic or average Resolution Time per month).

The app calculates its reports using already existing Jira issue histories so when you install the app, you don't need to add anything to your issue workflows and you can get reports on your past issues as well.

Time in Status reports can be accessed through its own reporting page, dashboard gadgets, and issue view screen tabs. All these options can provide both calculated data tables and charts.

Using Time in Status you can:

* See how much time each issue spent on each status, assignee, user group and also see dates of status transitions.
* Calculate averages and sums of those durations grouped by issue fields you select. (For example, see average InProgress time per project and per issue type.)
* Export your data as XLS, XLSX, or CSV.
* Access data via REST API. (for integrations)
* Visualize data with various chart types.
* See Time in Status reports on Jira Dashboard gadgets

https://marketplace.atlassian.com/1211756

EmreT