How to create calculated member on Transition to Status?

Questions & Answers
1

I have a report that shows the number of times an issue went from dev to QA and QA back to dev. I want to calculate the % of stories that went back to dev. I want to show a linear trend on failed stories (only on the number of times issues went back to dev). How do I create a calculated member for this?

image
image1561×412 6.39 KB

image
image995×309 6.59 KB

2

Is there anyone that can help with this?

3

Hi @dbosserman ,

The basic measure to see the trend might be as follows. This attributes failures to the period they are discovered - the period of backward transition.

CASE WHEN
([Measures].[Transitions to status],
[Transition].[QA => In Progress]) >0
THEN
([Measures].[Transitions to status],
 [Transition].[QA => In Progress])
/
([Measures].[Transitions to status],
[Transition].[In Progress => QA])
END

Still, it is possible that the backward transition from QA to In Progress happened in the following or even a later month. You might perform iteration through the relevant issues transitioned to “QA” within the relevant month and see if any of them were transitioned back to “In Progress” within the same or future periods. That measure would attribute the failure to the period of the faulty delivery.

The expression might be as follows.

CASE WHEN
 ([Measures].[Transitions to status issues count],
  [Transition].[In Progress => QA]) >0
THEN
Count(
 Filter(
  DescendantsSet([Issue].CurrentHierarchyMember, [Issue].[Issue]),
--sent to QA in relevant month
  ([Measures].[Transitions to status],
   [Transition].[In Progress => QA])>0
  AND
-- previous returns to QA subtracted from total returns to QA
  (CoalesceEmpty(([Measures].[Transitions to status],
                  [Time].DefaultMember,
                  [Transition].[QA => In Progress]),
                 0)
  -
   CoalesceEmpty(Sum(
               PreviousPeriods([Time].CurrentHierarchyMember),
               ([Measures].[Transitions to status],
               [Transition].[QA => In Progress])),
               0))
    >0)
)
/
([Measures].[Transitions to status issues count],
[Transition].[In Progress => QA])
END

Please note that the second expression might get slowish on larger datasets.

Regards,
Oskars / support@eazyBI.com