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?
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.
Janis, EazyBI support
The average counts of the issues should be created with the custom measures and using the "Avg" aggregator. For instance, the calculation like this:
[Transition status].[In Progress])
The report could be following:
Janis, eazyBI support
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...
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