Cycle time by few transition statuses

[Mitirrol]

Hi!
Help me please
I need to calculate the average cycle time using the formula:
** (Time in status 1 + time in status 2 + … + time in status 9) / Number of tickets in the sample **
I tried to use the Average number of days in the transition status and summed the required statuses, but it counts the time spent in the status divided by the number of transitions from the status.
This is how it looks:
Task 1: there are 10 transitions from the In progress status (as part of testing and revision), each time in the status was spent 1 day
Task 2: 5 transitions from the “In progress” status, each time for 1.5 days.

I need to calculate the average processing time for these tickets: (10 * 1 + 5 * 1.5) / 2 (number of tickets) = 8.75 days.
But it is considered this way: (10 * 1 + 5 * 1.5) / (10 + 5) = 1.17 days.

How to divide by the number of tickets in the formula?

[ilze.leite]

Hi @Mitirrol

Indeed, by default, the average is calculating dividing the total days with transitions, not the count of issues.

You may want to check out eazyBI demo report and measure “Average days in cycle” used with a custom cycle: Average lead and cycle time - Issues - Jira Demo - eazyBI

There are other threads related to similar use cases, you may want to check them out as well:

Cycle time distribution chart visible in JIRA

Hello guys, I would like to ask you for help. We are using JIRA and we need to see a Cycle Time Distribution Chart of our development, in order to provide more accurate estimates to stakeholders and to get more feedback on how consistently we deliver work in our teams. Example: https://d30s2hykpf82zu.cloudfront.net/wp-content/uploads/2018/11/Lead-Time-Distribution-Chart.png Could you guide me or help me how can I create it? Thank you!

Average time in defined statuses for whole issue lifecycle

Hello there, I think that I have a similar requirement. I need to report on the time from one status to another. The report shall show the average of this for all issues. In one case it is from one status to its direct successor, in the other there are some statuses in between. I tried the approach posted above in the first reply by Ilze and had the same issue as the other user. Time out. Another approach was to use Transition as a row and the Measure “Average workdays in transition status” …

Best,
Ilze, support@eazybi.com