Time in status not working properly

Question

When I extract the "time in status" via a google sheets addon it gives the following string:

10180_*:*_1_*:*_30579_*|*_10182_*:*_1_*:*_10061

I know the first value is the id of the status, the second is the amount of times it has been in this status and the third value is the time itself.

All goes well but for some reason, 1 status is always skipped even though the issues must pass this status according to the workflow.

Anyone with an idea why this is happening?

Michael Shelton_h9whr9 · Answer

I'm having the same issue where my last "in progress" status just before my "done" status is recording 0 time. My work around is to run a date-difference between the issues' created and completed dates, then subtracting the time spent in all other statuses. Also, my time in status is milliseconds not seconds. I wish this field worked more consistently

Yves Defossez · Answer

Hi Petru,

Thanks for your answer.

I am extracting the "time in status" field from the rest API call to Jira.

This gives me the information of "status ID", "# enters into this status" and "time in status" so I only need to do a lookup of the status ID and I know how long a ticket has been in a certain status.

It is just that for one status this is not counting properly. Recently I found out that it seems to be the last status before the ticket reaches the end status. So when I added a new "in progress" status between the one I wanted and the end status, it does get populated. Still not sure why Jira is doing this.

Petru Simion [Simitech Ltd.] · Answer

@Yves Defossez ,

To determine the exact time an issue spent in a specific status, you'll need to analyze the issue history and manually calculate the duration. This involves:

- Identifying the timestamp when the issue transitioned into the specified status
- Identifying the timestamp when the issue moved out of that status
- Calculating the time difference between these two timestamps
- If the issue repeatedly entered and exited the same status, you'll need to sum up the individual durations

You can then compare your calculated value with the value reported by your current app to identify any discrepancies.

If you're looking to avoid manual calculations for multiple issues, consider using Time in Status Dashboard for Jira , an app developed by our company. This app accurately calculates time spent in status, including repeated entries and exits, allowing you to compare its results with your current app.

You can chose between a perspective where each time in status is present in a separate column or

each status change is represented in a separate row

Not sure how you are extracting the data but this app allows you to export both perspectives in csv format.

One other thing you need to consider is if the status name you are mentioning could have been changed. There are various scenarios such as the status name changed once, or changed then changed back etc.

You will need to determine clearly from your History tab if this might have happened, which could explain "skipping" the status in a certain scenario. This can happen as you are not aware if the app you are using is using the status name or the status id (which does not change, even if the status name has been changed, and reflects as a changed status in the history).

Regards,

Petru