Lead + cycle time to replace JIRA Control Chart

Questions & Answers
4

Hi @Tiago_Santiago

You contacted us also on the support email. Below is the answer from there.

Cycle time over time
The time that takes to move one card from the cycle start to the end - custom cycle times are not yet possible with eazyBI, but you can create a measure that for each issue gets the transition to the cycle start status first date and cycle end status last date and get the average over a set of issues. Please try the following measure:

NonZero(Avg(Filter(
  Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
  (
    [Measures].[Transitions to status],
    [Transition Status].[CYCLE_END_STATUS]
  )>0),
  Datediffdays(
    (
      [Measures].[Transition to status first date],
      [Transition Status].[CYCLE_START_STATUS],
      [Time].CurrentHierarchy.DefaultMember
    ),
    (
      [Measures].[Transition to status last date],
      [Transition Status].[CYCLE_END_STATUS]
    )
  )
))

Please replace the “CYCLE_END_STATUS” and “CYCLE_START_STATUS” with the statuses that mark the beginning and end of the cycle.

Breakdown for each status
The time spent in each status (In Progress, Waiting, etc.) can be achieved with standard measure and dimensions - you can use the “Days in transition status” measure together with Transition Status dimension to see how much time is spent in each of the statuses. In the Transition status dimension, you can select only the statuses you are interested in. See a similar example here - https://eazybi.com/accounts/1000/cubes/Issues/reports/145950-average-cycle-time.

Kind regards,
Roberts // eazyBI support

1 Like