Cycle time per month

Questions & Answers
1

Hi,

I calculated a time to market (aka cycle time) measure using the formula:

image
image868×269 8.27 KB

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.

image

image
image713×309 15.7 KB

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.

image
image697×206 18 KB

Thanks!

2

Hi @isabela13,

Subtracting two average calculations won’t make sense :wink: . I recommend evaluating each issue separately, subtracting the two applicable values, and then calculating the average for that result over the particular issues.

The Avg() function, evaluating Issue dimension Descendants() could be useful. Please see an example here -Avg.

Best,
Roberts // support@eazybi.com

1 Like
3

Thanks @roberts.cacus . In the end, I am using the cycle time measures provided by EazyBI by default to build my report!

Have a nice week ahead,

Isabela

1 Like