First time Quality KPI

Questions & Answers
1

Hello,
I would put in place a report to the issues that are passing the first time from dev to QA to Done.

The probem I have is that the workflow keep changing and we can impact scripts

here is would take care to keep old measurement even if we change the workflow.

First workflow : ticket should pass from In Test(Rb) to Tested : once
updated workflow : ticket should pass ftom In Test to Finished

Here is my code but seems not effecient : could you please help optimizing it ?

Sum(
  Filter(
    -- iterate through issues
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    -- filter issues with a transition date from the status
    NOT IsEmpty((
      [Measures].[Transition from status first date],
      [Transition Status].[In Test],
      [Time].CurrentHierarchy.DefaultMember
    ))
    AND 
    DateInPeriod(
      [Issue].CurrentHierarchyMember.Get('Resolved at'),
      [Time].CurrentHierarchyMember
    )
    AND
    -- only one transition from status
    ([Measures].[Transitions from status],
    [Transition Status].[In Test],
    [Time].CurrentHierarchy.DefaultMember) = 1
    AND
    -- and the transition is to UAT pass
    ([Measures].[Transitions to status],
    [Transition].[In Test => Finished],
    [Time].CurrentHierarchy.DefaultMember) > 0
  ),
  ([Measures].[Transitions from status issues count],
  [Transition].[In Test => Finished])
)
/
Sum(
  Filter(
    -- iterate through issues
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    -- filter issues with a transition date from the status
    NOT IsEmpty((
      [Measures].[Transition from status first date],
      [Transition Status].[In Test],
      [Time].CurrentHierarchy.DefaultMember
    ))  
    AND 
    DateInPeriod(
      [Issue].CurrentHierarchyMember.Get('Resolved at'),
      [Time].CurrentHierarchyMember
    )
    AND
    -- and the transition is to UAT pass
    ([Measures].[Transitions to status],
    [Transition].[In Test => Finished],
    [Time].CurrentHierarchy.DefaultMember) > 0
  ),
  ([Measures].[Transitions from status issues count],
  [Transition].[Transition].[In Test => Finished])
)
2

Hello @Ibrahim ,
Please try this formula that should work faster than your original.

CASE WHEN
    -- and the transition is to UAT pass
    ([Measures].[Transitions to status],
    [Transition].[In Test => Finished]) > 0
THEN
 Avg(
 Filter(
  Filter(
    -- iterate through issues
    DescendantsSet([Issue].CurrentMember, [Issue].[Issue]),
    -- filter issues with a transition date from the status
    DateInPeriod(
      [Measures].[Issue resolution date],
      [Time].CurrentHierarchyMember)
    ),
    -- and the transition is to UAT pass within period
    ([Measures].[Transitions to status],
    [Transition].[In Test => Finished]) > 0
    ),
  CASE WHEN
    -- only one transition from status
    ([Measures].[Transitions from status],
     [Transition Status].[In Test],
     [Time].CurrentHierarchy.DefaultMember) = 1
  THEN
    2
  ELSE
    1
  END
)
-1
END

You can also check this documentation page about optimizing MDX formulas.

If you need further adjustments, please write directly to support@eazybi.com and, please, include your report definition.

Kindly,
Gerda // support@eazybi.com