Management is looking to add a date difference column

[Naresh Rajak]

Hello,

Management is looking to add a date difference column 

 that shows how many days since status was first changed to 'In Progress'.

I am new and has not used J Query. Keen to learn if the solution requires using J Query.

Simple solution is preferred.

Thank you for taking time to read. Please help.

Regards

Naresh

[Bill Sheboy]

Hi @Naresh Rajak 

That measure is sometimes called the "Age of WIP", and there is nothing built-in to measure it.

There are marketplace apps for such time-in-status tracking (reading the information from the issue history).  Or you could use custom fields and an automation rule to help.

For example, let's assume an issue never has "backwards flow", to return to a "To Do" status once it is "In Progress".  In that case, using the statusCategoryChangeDate value one may use a scheduled trigger rule to calculate the value:

https://community.atlassian.com/t5/Automation-questions/Hi-community-nbsp-nbsp-How-about-Age-of-WIP-work-item-age-1/qaq-p/1561072/comment-id/12504#M12504

When "backwards flow" can happen, the first transition to an "In Progress" type status may be saved in another variable (or entity property) and used for later calculations.  This would require an additional rule.

Kind regards,
Bill

[Benjamin]

HI @Naresh Rajak ,

There isn't an out of the box solution that is tracking the counter. You may want to check Atlassian marketplace apps. Looks for key words like "status and time". Usually, you can trial apps for 30 days to see if it serves the purpose you need.

-Ben