Transition from Status One to Other

Questions & Answers
1

I want to create a Charts to display the Issues Average time based on (Status & Transition Status)

  1. From Candidate for Delivery to Done
  2. From Scheduled for Delivery to Done

and followed the
EazyBI - Transition from Status A to Status B - un... but it didnt work as expected

2

It can be done in 2 different ways:
Option A (no custom cycles defined or specific cycle for you inside from another).
With a report using the dimensions Time, Measures and Transition status, it would be enogh.
in the rows: Time (by month or whatever)
In the columns: The Measure dimension with the “Average days in transition status” or for working days: “Average workdays in transition status” and the DImension Transition status created with your desired hierarchy like:


Aggregate({
[Transition Status].[Candidate for Delivery],
[Transition Status].[Status intermediate A],
[Transition Status].[Status intermediate B],
...
without adding the "Done" status
})

It should be enough. Example:

image
image1920×1232 111 KB

The other way around is with the custom cycles defined in your source data which gives you the metrics for the time, amount of issues, etc… inside it
If you go into your Source data and edit it, you will be able to add/edit at the 1st tab, for instance:

image
image1648×766 55.8 KB

And it will create these default measures (for instance for my Backlog cycle):

image
image1346×304 34.7 KB

1 Like
3

Thank You it helps lot and I am able to use the above

4

Hello @SAM2022 ,
Alternatively, you can use this formula to calculate the average days between two specific transitions.

Avg(
  -- Filter issues based on specific transition criteria
  Filter(
    -- Get all issues from the current hierarchy
    DescendantsSet([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    -- Check if the issue has transitioned from 'Candidate for Delivery' status
    (
      [Measures].[Transitions to status],
      [Transition Status].[Candidate for Delivery],
      [Time].CurrentHierarchy.DefaultMember
    ) > 0
    AND
    -- Check if the issue has transitioned to 'Done' status
    (
      [Measures].[Transitions to status],
      [Transition Status].[Done]
    ) > 0
  ),
  -- Calculate the number of days between first 'Candidate for Delivery' and last 'Done' transition
  DateDiffDays(
    -- Get the date of the first transition from 'Candidate for Delivery' status
    (
      [Measures].[Transition to status first date],
      [Transition Status].[Candidate for Delivery],
      [Time].CurrentHierarchy.DefaultMember
    ),
    -- Get the date of the last transition to 'Done' status
    (
      [Measures].[Transition to status last date],
      [Transition Status].[Done],
      [Time].CurrentHierarchy.DefaultMember
    )
  )
)

This formula calculates the average time (in days) it takes for issues to move from the ‘Candidate’ status to the ‘Done’ status, considering only issues that have gone through both of these statuses.

Kindly,
Gerda // support@eazybi.com