In progress Cycle

Questions & Answers
1

Hi, I am using In Progress cycle to get the team average cycle time fro in progress status. This is not complete. I would like to be able to also get the In progress status cycle. this will show me from the entire in progress cycle time, team spend 40% in progress status.

If I create a new cycle for In prosgress status is not working, is I use days in transition status is not working because we do not have the same issues selected.

So In progress cycles for the last 30 days shows 4 issues 1,2,3,4 and in progress cycle staus shows the data for other issues, so is not matching well. Can you help?

cheers.

adrian

2

Hi,

The “In Progress cycle days” measures show issues that completed the entire cycle in the selected period (last 30 days), while “Days in transition status” shows issues that transitioned out of a specific status during the period. These are different sets of issues, as you have correctly observed, and this is why your comparison doesn’t match.

In this case, you should create a calculated measure that ensures both metrics use the same set of issues. You might want to calculate the percentage in “In Progress” status only for issues that have completed the whole cycle. The expression for calculation might look as follows:

--total time issue with ended In Progres cycle spent In Progres status
Sum(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    -- Only include issues that ended the In Progress cycle in the selected period
    DateInPeriod(
      [Measures].[Issue In Progress cycle end date],
      [Time].CurrentHierarchyMember
    )
  ),
  -- For these issues, get the time spent in the specific "In Progress" status
  (
    [Measures].[Days in transition status],
    [Transition Status].[In Progress],
    [Time].CurrentHierarchy.DefaultMember
  )
)
--divided by issue with ended In Progres cycle (same set of issues) spent in cycle
/
[Measures].[In Progress cycle days]

Please review the expression and update the “In Progress cycle” in lines 7 and 20 to the cycle name you have in your eazyBI. Set measure formatting to percentage %.

More details about issue cycle measures, transition status measures, and how to build calculated measures are described in the documentation:

Best,

Zane / support@eazybi.com