Calculate the duration of time between a date field and when a ticket transitions to a status

Steve Holota_1q6az4

I have a Jira Structure board setup to track the work for our domain architects.

Issue types in use are Tasks, Epics, Features, so this means different workflow states.

I'm using the TargetStart field as the date the requirements are ready for the architect. I then am using the status of "Done" (for Tasks) and "Waiting for Implementation" (Features/Epics) to signal that the architect has completed their work.

I need a formula column to calculate the time between the date and the status please

Stepan Kholodov

Hello @Steve Holota 

You can use a formula like this:

days_between(targetstart, history.changes.filter($.field = "status" and $.to = "done").last().changegroup.time)

This example formula will take an issue's  date of last transition to 'Done' and compare it with the given Target Start date.

I hope this helps. If you need further assistance of have other questions about structure, please reach out to us directly at our support portal.

Best regards,
Stepan
Tempo (the Structure app vendor)