Hello, I am trying to get the average cycle time for epics or stories, being that the average time spent in a specific set of statuses, and I ended up looking at the following example I have seen in other posts:
I saw there " Average days in cycle shows an average of total time spent issue spent in is specified statuses represented by Transition status dimension", which does what I need when I calculate the total cycle time. I have another need that is to show that total split into the different statuses (stacked bars with the average for each of the statuses that makes the total). The problem I have with that is that the averages are calculated based on the number of issues that have been in that specific status instead of the total number of issues, so averages of different statuses are calculated on a different number of epics/stories. That happens because we have some statuses that are not mandatory, so not all issues go through them. Issues not going through a specific status would contribute 0 to the total time spent in that status, but they would contribute to the count of issues considered for the average.
I would need to calculate the averages for different statuses on the total resolved issues in the period instead of on the number of issues that have gone through that specific status, how could I achieve that?
Thanks in advance for your help