Jira Automation: Show # of Days (in decimal format) Once Sub-Task Transitioned to Done status

Akash Panchal

Hey everyone,

I'm looking to add a Jira automation rule for the following:

- IF sub-task transitioned to DONE status, THEN show the # of days it took to complete the sub-task in a field on the sub-task screen

 

I have been able to accomplish this by adding the following within a field called "Total Duration":

{{issue.created.diff(now).days}} Days

 

The problem is that this displays the following:

- Example:

- Created: 8/24/23 & 8:00AM

- Transitioned to DONE: 8/24/23 @ 5:00PM

- Total Duration: 0

 

The total duration is rounding to the nearest whole day, not showing partial days. In the example above, the sub-task took 9hrs to complete which is 9/24 --> 0.375 Days. How can I get it to show days in a decimal format?

 

Thank you!

Bill Sheboy

Hi @Akash Panchal 

Have you tried using either:

• Diff on hours, and then divide to get your fractional amount, or...
• Use a much more complicated rule, accounting for working/non-working days and hours.  Such a rule would perform multiple diff(), remove weekends and non-working hours, etc.

The approach you use will depend upon your specific scenario / needs.

And also...what you seem to be measuring is often called Lead Time (i.e., from request to completion time).  If you want the actual working time you could use the built-in Control Chart report, or do something a bit more to measure in-progress time, like with this how-to for Age of WIP: https://community.atlassian.com/t5/Automation-discussions/What-is-your-most-useful-automation-Here-is-mine/m-p/1561072#M34

Kind regards,
Bill