We have a need for Reports of all projects related to new tickets and more

Question

In order to build / plan / forecast what moves to take to improve support and staff, we need reports. We are using Jira Service Management as ticketing system and so far creating filters and then dashboard has gives us ugly and and not usable view what is happening.

I'm sure there is better way of doing it for sure and there are companies that have the same goal and problem.

Reports that we need are:

* New tickets created per month - view all year
* Average ticket age per month - view all year
* Resolution times per month - view all year

Please help, Copilot cannot further on this.

Rahul_RVS · Answer

Hi @[deleted]

Welcome to the community !!

If you would be interested in a mktplace app for this requirement, you can try out

Time in Status Reports

With this app you generate time in each workflow status for multiple issues with multiple filter and grouping options. You can also extract trends analysis and add that as a dashboard gadget too.

The app shows Avg Time in Status report. Also the app allows to group your statuses to define your own resolution times.

More details here.

Disclaimer : I am part of the app team for this add-on

Valeriia_Havrylenko_SaaSJet · Answer

Hi @[deleted]
Welcome to the Community!

Also if you are open to try a marketplace solution, Time in Status can be a great solution. Add-on provides detailed time tracking reports that help you analyze support performance. Here’s how you can set up the reports you need:

1. New Tickets Created Per Month – View All Year

Use Jira’s built-in Created Issues Report to track the number of new tickets each month.

2. Average Ticket Age Per Month – View All Year

Use the "Average Time Report" in Time in Status to see the average age of tickets.

You can filter data by month, project, request type, or priority to get a more detailed view.

This helps identify aging tickets and improve response strategies.

3. Resolution Times Per Month – View All Year

The "Time to Resolution" report in Time in Status tracks how long it takes to close tickets.

It can break down data by month, team, or issue type to find bottlenecks in the support process.

You can export this data to Excel or Google Sheets for deeper analysis.

Add-on developed by my team.

I hope you find this helpful 🚀

Gizem Gökçe _OBSS_ · Answer

Hello @[deleted],

Welcome to the community

It sounds like you're looking for a more efficient and insightful way to track key metrics for your Jira Service Management system. Timepiece - Time in Status for Jira can help you easily generate the reports you need with clear and actionable views. Here's how Timepiece can support you:

Duration Between Statuses report, which can cover both:

New Tickets Created per Month: You can track when tickets were created and group the results by Created Month. This will give you a monthly breakdown of new tickets created throughout the year.

Average Ticket Age per Month: The same Duration Between Statuses report can also be used to measure the age of tickets by tracking the time from issue creation to today, grouped by Created Month to give you an average view of ticket age over the year.

Resolution Times per Month: The Duration Between Statuses report in Timepiece lets you track how long tickets take to move through specific statuses, such as from "To Do" to "Resolved". If you need you can also group the issues by their Created Month and have the average or sum value of the resolution times per month.

These reports can be viewed on your reporting page, dashboard gadgets, or directly in the issue view. Timepiece provides both data tables and charts for a more visual, digestible view of the data, and you can export reports in CSV or XLS formats.

Timepiece works with your existing Jira workflows, so there's no need for major changes—just install the app and start generating detailed, actionable reports. Let me know if you need further clarification.

Hope it helps,

Gizem