Time in "In progress" when the issue gets transitioned to this status

[Nikola Perisic]

Hello

I want to show the days when the issue has been transitioned to the in progress status. I have used 3 automation rules:

1. Todays date 

2. In progress date

3. Days

I have created 3 custom fields: 2 date pickers and 1 number field that needs to show the exact number of an issue being in the in progress status.

All automation rules work except the third one that I found from one of the articles here.

When the 3rd one executes, there is no number being shown, only the "None" value.

Where am I mistaking?

[Bill Sheboy · Accepted solution]

Hi @Nikola Perisic 

The reason that may not be working as expected is you probably want your 3rd rule to be triggered by the actions of the second one.  That is disabled by default to prevent errors.  When you want one rule's actions to trigger another, enable the "Allow Rule Trigger" option in the details of the downstream rule only.

For another approach to measure Age of WIP (or time in progress), please see this post for a rule using the status category:

https://community.atlassian.com/t5/Automation-discussions/What-is-your-most-useful-automation-Here-is-mine/td-p/1560668#M34

Kind regards,
Bill

[Nikola Perisic]

@Bill Sheboy That actually worked. Also, do you think that instead of {{now}} I should be using the {{issue.created}}, since for now it will show the today's date and also when you do the subtraction it will always be 0?

[Bill Sheboy]

With automation rules, timing is important.  The better accuracy value will be {{issue.created}} as delays in automation rule processing could add significant time, particularly if there is an Atlassian outage and the rules need to "catch up".

I am unclear on what you mean by "when you do the subtraction it will always be 0".  Would you please explain?

If you mean using {{now}} versus {{issue.created}} for the later comparison to {{issue.updated}}, {{now}} is...well...now.  And so the value is likely to be different enough, even during the execution of a single rule with a non-trivial amount of work to do.

[Valeriia_Havrylenko_SaaSJet]

Hi @Nikola Perisic  👋

Maybe this article will help you - Time in Status email notification.
In the article i explain how to set up notifications based on time in a status custom with Time in Status for Jira. But you can get email notifications based on issues in particular statuses without add-on too. 

Also  Time in Status for Jira has a custom fields option, so you will get days when the issue has been transitioned to the in progress status directly on your card and board.

Add-on has a 30-day free trial version and  free up to 10 users.
Hope it helps 😌

[Jehan Bhathena]

Hi @Nikola Perisic ,

I assume you're trying to time track the status.

https://marketplace.atlassian.com/apps/1222051/status-time-reports-free-time-in-status?tab=overview&hosting=cloud

Try using this plugin, its free on the marketplace and might solve your use case Without the automation 🙂

[Nikola Perisic]

Thanks @Jehan Bhathena !

I actually need the automation without the app :)

[Paul Pasler]

Hi @Nikola Perisic

yet another third party app solution :)

With our free app Awesome Custom Fields we provide a Time in Status field. It saves the value into the field, so you can use it for further investigation. You may also get the status history in the edit dialog.

Cheers,

paul

[Gizem Gökçe _OBSS_]

Hello @Nikola Perisic ,

As far as I understand, your primary choice is not an app, but if you would like to evaluate it, I would like to introduce you to a very advanced tool with which you can easily access the reports/results you request. 

I can recommend Timepiece - Time in Status for Jira which is built by my team at OBSS. It is available for both  Jira Cloud, and Data Center. 

Our app has a free 30 day trial and is free for up to 10 users. So please feel free to give it a try.

Time in Status mainly allows you to see how much time each issue spent on each status or each assignee. In addition, you can see the transition dates of the issues to a certain status and see how many days/hours it spent on a particular status like you are trying to achieve with Automation Rules. 

For all numeric report types, you can calculate averages and sums of those durations grouped by the issue fields you select. For example total in-progress time per customer or average resolution time per sprint, week, month, issuetype, request type, etc. The ability to group by parts of dates (year, month, week, day, hour) or sprints is particularly useful here since it allows you to compare different time periods or see the trend.

Timepiece - Time in Status for Jira 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. It supports both Company Managed and Team Managed projects for Jira Cloud.

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.

Hope it helps,

Gizem