Hi,
I calculated a time to market (aka cycle time) measure using the formula:
But now I want to see this measure only for my closed epics by month. But when I create the table, for instance, for January 2024 only 1 epic that was closed with cycle time 6,03. Why I do not have this same value 6,03 at the main line (without doing the drill through the issues)? I got a 5,35 instead of 6,03.
For the other months, the value does not make senses either. For instance, April, 19,11 is such a small value compared to the individual cycle times.
Thanks!
Hi @isabela13
Instead of removing statuses in the custom calculation, you may want to define cycle time with all valid statuses and then use standard calculation “Average days”: read, how to define and use cycles Issue cycles
The calculation returns unexpected results because you need to do the distraction on the issue level (when you iterate through issues, in the Descendants part) and then get the average value from already calculated cycle time from all the issues. However, calculations with iterating through issues is slow. I think you should try out the issue cycle standard calculations first.
Best
IlzeLA, support@eazybi.com
Many thanks, I got exactly what I need!
Best wishes 
1 Like
