Story cycle time help!

Questions & Answers
2

Here is one report example in our demo account on cycle times. This report works on historical status change and will count total time in any status from status category In Progress (Transition status hierarchy by Category In Progress).

The measure Rolling Average cycle time also includes an alternative solution, to an average time spent within a specified list of statuses.

However, if this report example, does not suit you. You can define a new calculation based on the time when an issue moved to a particular status. In this time, I used a measure Transitions to status last time in a tuple with Transition status In Progress, and default time member to get a date and time when an issue moved to the status In Progress for the last time.

I am calculating this time until an issue was resolved and show the value for resolved issues in a period:

NonZero(AVG(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    DateInPeriod(
      [Measures].[Issue resolution date],
      [Time].CurrentHierarchyMember
  )),
  CASE WHEN [Measures].[Issues resolved] > 0
  THEN
    DateDiffDays(
      ([Measures].[Transition to status last date],
      [Transition Status].[In Progress],
      [Time].CurrentHierarchy.DefaultMember),
    [Measures].[Issue resolution date]
    )
  END
))

We suggest using some issue properties for calculations on issues. In this case, I am using Issue property Issue resolution date for the main filter and in dateDiffDays function as an end date of the cycle as well.

You can use issue property Issues closed date and measure Issues closed instead.

Daina / support@eazybi.com

1 Like