It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Lead and Cycle Time in eazyBI Edited


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


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




2 answers


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

0 votes

Hi guys,


Could you please share your definitions ?

I'm trying to replace control chart from jira, with something in eazyBI like this:


1) cycle time over time

2) breakdown in sub-groups

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Marketplace Apps & Integrations

Localize Smarter with the Transifex Integration for Bitbucket

Over 52% of internet users say obtaining information in their own language is more important than price and 75% of the world’s population doesn’t speak English. It’s no wonder then that successful gl...

231 views 0 3
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you