Time in Status

Question

I am trying to add a comment that the issue has been in status for these many days after a transition. I have tried the below two statements in automation and both returns 0.

This issue has been in the status for {{issue.updated.diff(issue.updated).days.abs}} days.
This issue has been in the status for {{now.diff(issue.updated).days.abs}} days.

Any help is appreciated .

Amay Purohit_RVS · Answer

Hi @Devi

If you are open to try out a mktplace app to get this data, you can take a look at

Time in Status Reports

The time in status report shows the time spent by your issues in each status during the entire workflow.

The app has 20+ reports to track your bottleneck Issues & Processes.

More details here

Disclaimer : I work for the vendor who built this app

Mehmet A _Bloompeak_ · Answer

Hi @Devi

If you prefer using a marketplace app to get time in status info, you can try 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 your case, you can have a look at Time in Status for Each Issue report.

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

App Features:

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

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

Hope it helps.

Iryna Komarnitska_SaaSJet_ · Answer

Hi @Devi ,

I can offer you a solution - directly add the amount of time spent in the status to the issue card.

This is possible with the Time in Status for Jira app (developed by my team).

Here's a link to the detailed set guide. The app has a 30-day free trial.

I hope this will be useful to you.