Using JWT Calculated Number Field how to get time between Created and a Status

Question

I'm currently using JWT Calculated Number Field for getting the resolution time (resolution date - created date)

Now, I'm trying to create several time trackers and would like to ask for help since I can't get it working.

For example, time between created and change status to in progress. Or created to first public comment.

Marc Jason Mutuc · Answer

so you're trying to export your issue navigator result to *.CSV and receive your durations in pretty short format, e.g. 1d 1h 34m, instead of 920611160000000 ms? >>> On display it would say 1d 1h 34m but on extract it would instead be 920611160000000.

I'll check it out and let you know how it goes. Thanks!

Thorsten Letschert _Decadis AG_ · Answer

Hi @Marc Jason Mutuc,

so you're trying to export your issue navigator result to *.CSV and receive your durations in pretty short format, e.g. 1d 1h 34m, instead of 920611160000000 ms?

If this value is for reporting purposes mainly, I'd rather suggest using a Calculated Text Field with the following expression:

shortFormatDuration(timeInStatus("Done"))

That way, the display in Jira stays the same, but the *.CSV export will also include the pretty format 1d 1h 34m.

Does this help with your requirement?

Marc Jason Mutuc · Answer

Thanks! I've also been experimenting on the fields a bit. And for the number field, when you extract, it would always be in milliseconds. The extract is in csv. Is it possible to make the extract be what the display is or at list convertible into seconds?