is it possible to get a ticket's timeline as a breakdown on the chart or table?

Question

Here in example below, there is 1,5month between two responsible's action.

I need a chart to track the time difference between the actions taken by 2 supervisors to reduce this long period. Is Jira able to create it in this specific manner?

thanks in advance.

meral.cetintas@daimlertruck.com

Mehmet A _Bloompeak_ · Answer

Merhaba @meral cetintas ,

To get a report of time spent on each status, I can recommend Status Time Reports app developed by our team. It mainly provides reports and gadgets based on how much time passed in each status.

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

For example, if you want to get a report of how much time passed on each status of an issue, you can have a look at Time in Status for Each Issue report. This app has a dynamic status grouping feature so that you can generate various valuable reports as time in status, time in assignee, status entry dates and status counts, cycle time and lead time, resolution time, average/sum reports by any field(e.g. average in progress time by project, average cycle time by issue creation month).

For further details, you can have a look at Status Time Reports How to Videos.

App Fetures:

* You can search issues by Project, Issue Type, Status, Assignee, Issue Creation/Resolution Date(and any other Date field) and JQL Query.
* Status durations are calculated according to the working calendar you define. 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.
* You can set different duration formats.
* You can export reports in CSV file format and open them in MS Excel.
* You can also add this app as a gadget to your Jira dashboards and reach “Status Time” from Issue Detail page.
* You can enable/disable access to Status Time reports&gadgets and Issue Detail page per project, users, groups or project role.

If you are looking for a completely free solution, you can try the limited version Status Time Reports Free.

If you have any questions, feel free to schedule a demo with us.

Hope it helps.

Hannes Obweger - JXL for Jira · Answer

Hi @meral cetintas

welcome to the community!

As you've surely noticed by now, this is an area in which a number of Marketplace apps operate. If you're open to solutions from the Marketplace, I think you'd like the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of so-called history columns that aren’t natively available, including time in [status], time between [status] and [status], and many more.

This is how it looks in action:

As you can see above, you can easily sort and filter by your history columns, and also use them across JXL's advanced features, such as support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

Valeriia_Havrylenko_SaaSJet · Answer

Merhabalar @meral cetintas  👋

Atlassian Community'e hoşgeldiniz!

I believe that Time in Status will help you with your issue. We have a lot of features to help you, so I recommend you book a live demo for add-on. We'll show you the application inside out and answer all your questions.

So, you can find bottlenecks in a table view report with Smart view feature.

Chart view is also available.

Also, you can display the time spent in a particular status in a custom field to reduce long periods of staying at one status.

For more in-depth data analysis, you can create reports as pivots. For example, you can look at the percentage of time spent in different statuses.

Dashboards gadgets feature will keep your finger on the pulse and track team productivity in real-time.

For Scrum teams we are also offering Sprint Report feature in Time in Status

Add-on have 30-day free trial, free up to the 10 users and developed by my team.

I hope you find this helpful 🚀