The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Formula Calculated Date?

Markus
Contributor
September 18, 2018

I've created two "Transition Date fields" in Jira to get the time when two specific transitions took place. 

In both of those field i have this:

<!-- @TransitionId: theTransitionIDFromMyWorkflow -->

this actually works. Now i want a third field to calculate the difference between field A and field B. 

I thought about something like:

<!-- @@Formula:
return issue.get("FieldB") - issue.get("FieldA");
-->

So value of field B - Value of field A. But this sadly doesnt work. Im sure that its some syntax issue or something is missing... any idea how to fix this?

2 answers

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

0 votes
Emre Toptancı _OBSS_
Atlassian Partner
June 26, 2019

If you are interested in a ready to use solution, Time in Status app by OBSS produces reports that show the first and the last status transition dates for each status. The app also includes reports that show how much time each issues spent in each status, assignee or group and finally number of times each status or transition was used.

All report data can be exported as XLS, XLSX or CSV.

0 votes
Gonchik Tsymzhitov
Community Champion
April 10, 2019

Hi! 

Do you really need to do it immediately? 

Maybe async by event you can overwrap it?

Cheers,

Gonchik