How can I get dates regarding the start and end of resolving issue?

Question

Hi,

we have a development KPI that measures time spent on epic. It is defined as an interval between a date when the first issue of the epic enters IN PROGRESS column (and gets In Progress status) and a date when all issues are resolved (i.e., last issue enters DONE column/gets Done status).

We are looking to automate the KPI measurement. Is there a way to do it in JIRA (are there relevant fields we could define/exploit?)? Is there a way to do it through REST API (are there relevant endpoints/what are the possible relevant endpoints)?

Thank you,

Pavlina

Paula Pokusa_iijq56 · Answer

@Ste Wright I am looking for start date as well and happen to have Time in Status, however have never used it. Do you know any more as far as how to utilize it to get that data? Thanks!

Mehmet A _Bloompeak_ · Answer

Hi @Pavlina Novakova ,

We released the new feature of displaying status entrance dates. You can view/export the status entrance dates and work on it.

Mehmet A _Bloompeak_ · Answer

Hi @Pavlina Novakova ,

The data you need is available in Jira Rest API. It provides the exact status transition date and time for each issue. It returns json as below, then you need to extract and calculate the date differences. You should loop for all the issues under the epic, take the minimum of In Progress dates and maximum of Done dates.

Or you can try Status Time add-on. It generates status time report/export. It calculates status duration on issue level. As of now, it does not provide status entrance date in the report but just upon your case we started working on it. We will release status entrance date feature in a few days.