Lead and Cycle Time in eazyBI


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:


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


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


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

Thank you




1 answer


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]

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:

([Measures].[Issues history],
[Transition status].[In Progress])

The report could be following:

Weekly average.png


Janis, eazyBI support

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published Thursday in Marketplace Apps

Calling all developers––You're invited to Atlas Camp 2018

 Atlas Camp   is our developer event which will take place in Barcelona, Spain  from the 6th -7th of   September . This is a great opportunity to meet other developers and get n...

327 views 0 6
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