Working out Time between next and Done

[Simeon]

I want to add two automations, one to set the date that a ticket arrives in my next column and then once it moves to complete, calculate the time between that set date and now.

I seem to have everything correct based on every post I have looked at but it just does not work.

I created a custom field called DateInNext, I have tried a date picker and a datetime picker.  Then using an automation set that to be {{now}} on the transition, this seems to work and the field is populated, then I create another automation on transition to complete and I get nothing.

I am starting with putting it into comments in the automation:

Cycle Time:{{now.diff(issue.customfield_ 12940).businessDays}}

Cycle Time:{{now.diff(issue.created).businessDays}}

I get a number when using the .created field, but. not when I use the custom field.

Yes, I know there are lots of add ins that I can use, but the client I am working with will not spend money - so thought this would work - PLEASE can someone help??

[Trudy Claspill · Accepted solution]

Hello @Simeon 

Welcome to the Atlassian community.

Please show us your complete automation rule.

What  is the customfield_12940 field? Also, it looks like there might be a blank space between the underscore and the "1" in what you pasted. That might just be a paste error, but double check that there is no space in the actual code.

[Simeon]

Huge thanks, missed the space!!!

So the custom field is a date picker that I fill with {{now}} on transition to next.  Then once I get to Complete I want to populate the cycle time with now-custom field.

All worked exactly as I thought it would but I had a space - so well spotted - thanks

[Valeriia_Havrylenko_SaaSJet]

Hi  @Simeon   👋 

To check cycle and lead time, as an alternative, I guess you can try Time in Status for Jira Cloud. The primary purpose is to help teams gather valuable data about the lifecycle of your issues in Jira. Add-on allows you to measure and visualize the time spent in each status, such as "Open," "In Progress," "In Review," and "Closed," and provide 7 types of reports to help you identify areas for improvement. Add-on developed by my team.

 
Also Time Between Statuses will be an option for you too. This add-on, which measures connections in the workflow, through a transition time in specific issues. You can count Cycle and Lead Time by setting start/stop and pause statuses in the configuration manager. This add-on also developed by my team.

Add-ons have a 30-day free trial version and free up to 10 users. 
Please, let me know if you have any questions

Hope it helps 😌
Valeriia