Lead and Cycle Time in eazyBI

Hi,

I am trying to calculate the Cycle time in eazyBI. I first tried using Transtion in rows and selecting the transitions from the project. In my case:

- Backlog = > Selected for Development
- Selected for Development => In Progress
- In Progress => Test
- Test => Done

In Columns I used Average workdays in transition status. I got as an average aroung 2 workdays. See image

temp 1.PNG

This results are not very realistic for my team, so I did a bit more research and I found this article were it is shown how to calculate it in eazyBI:

https://mraddon.blog/2017/10/07/how-to-calculate-lead-time-or-real-average-resolution-days-with-eazybi-and-jira/

I followed all the steps and this gives me a Cycle Time average of 13 days. See image below:

temp2.PNG

But if I check in JIRA Reports (Control chart), it calculates 1w 2d of average (workdays).

temp3.PNG

How can I reproduce the results from JIRA in EazyBI? Why are the results so different?

Thank you

Nuria

 

 

1 answer

This widget could not be displayed.

Hi,

For the cycle time calculations, we suggest the approach described in the blog article you mention. However, the calculation mentioned there relays on the Issues resolved measure which is used as the count to calculate the average of the cycle time.

Although I would not claim to reproduce the way how Jira control chart works entirely, it seems that Jira control chart includes in the calculation of the cycle time all the issues which had any of the statuses mentioned in the status list of the report. The indication of this could be the amount of the issues included in the calculation from your example (Issues resolved: 122, control chart: 142), provided you have defined the same scope of the issues for both reports.

There are default measures in eazyBI "Average days in transition status" and "Average workdays in transition status" giving the number of days issues spent in the transition statuses which seems similar to what Jira control chart provides.

I did a couple of experiments and also found that Average days in transition status in eazyBI works differently from the control chart calculation. When an issue had several completed cycles, eazyBI calculates the average per completed cycle, while the control chart gives the average per issue. I redefined the average measure to be more like that in the Jira by the formula:



CASE WHEN [Measures].[Transitions from status issues count] > 0 THEN
[Measures].[Workdays in transition status] /
[Measures].[Transitions from status issues count]
END

Now when I combine the measure in the report with the status of the Transition status dimension, the average seems very much like that in the control chart. Just a final remark: double check if your issue scope in eazyBI report corresponds to that of the control chart.

Best regards,

Janis, EazyBI support

Is there a way to tweak this to find Average Issue count In Progress per week?

Hi John-Michel,

 

The average counts of the issues should be created with the custom measures and using the "Avg" aggregator. For instance, the calculation like this:

Avg(
[Time.Weekly].[Week].Members,
([Measures].[Issues history],
[Transition status].[In Progress])
)

The report could be following:

Weekly average.png

Kindly,

Janis, eazyBI support

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Published Jul 25, 2018 in Marketplace Apps

Jira Cloud and Bitbucket Cloud Integration with Microsoft Teams

One of the newest products in the Microsoft family - Microsoft Teams,  is a chat-based hub for teamwork that integrates all the people, content, and tools your team needs to be more engaged and ...

727 views 0 3
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you