Report for individual tickets time from open to closed

Question

Looking for a way to report on individual ticket times from the time it was created to resolved.

I see reports that are based on SLAs but they are averages.  I would like to be able to see on individual tickets the time from Created to Resolved.

For example if I want a filter for a single user how much time was spent on individual tickets.  Then for us to be able to spit that out into excel.  I am having a hard time putting this together.

Mehmet A _Bloompeak_ · Answer

Hi @Natalie Franklin ,

As an alternative, you can try Status Time app developed by our team. It provides reports on how much time passed in each status.

Once you enter your working calendar into the app, it takes your working schedule into account too. That is, "In Progress" time of an issue opened on Friday at 5 PM and closed on Monday at 9 AM, will be a few hours rather than 3 days. It has various other reports like assignee time, status entry dates, average/sum reports by any field(eg. average in progress time by project, average cycle time by issue creation month). And all these are available as gadgets on the dashboard too.

Here is the online demo link, you can see it in action and try.

If you are looking for a free solution, you can try the limited version Status Time Free. Hope it helps.

Yuliia_Borivets__SaaSJet_ · Answer

Hi @Natalie Franklin

You can also check out Time in Status for Jira Cloud app developed by my team. To find how much time each user spent on individual tickets, you may try the pivot table feature. Here is a short guide:

1. Select the Pivot table view.

2. Choose the Fields option.

3. Drag and drop such fields:

* Summary and Assignee → Rows
* Time (hours) → Values
* Status → Columns

As result, you'll get a table with every team member's time spent on issues:

You can try the online demo version without installing it.

Let me know if this helps or if you have any questions.

Ilze Leite-Apine - eazyBI · Answer

Hi @Natalie Franklin

Thanks, @Fabian Lim for mentioning eazyBI, an app for data analysis and charts.

Indeed, eazyBI has a predefined measure "Average resolution days" (also workdays) that counts days between Created and Resolved. Used with issues in the report rows, it shows the total resolution days for each issue.

There are several reports in the eazyBI demo account with this measure:

https://eazybi.com/accounts/1000/cubes/Issues/reports/97436-issue-resolution-days-lead-time  (a table with issue types in rows, not issues, but issues can be used instead of issue types freely)

https://eazybi.com/accounts/1000/cubes/Issues/reports/91815-issue-resolution-time-boxplot-chart (resolution as a boxplot chart)

Also, there is an option to analyze data by resolution intervals, if you want to see issues split by buckets based on their resolution intervals, an example here https://eazybi.com/accounts/1000/cubes/Issues/reports/50399-issue-resolution-intervals-lead-time

Feel free to contact support@eazybi.com for further assistance or any questions!

Best,

Ilze // support@eazybi.com