First time pass percentage metrics

Hi,

I would like to get the first-time pass percentage of total runs from first day execution of story/epic.

Kindly help me to get the metrics

Thanks
Niranjan

Hi,

The following formula counts the tests that had PASSED status at the first test execution:

Nonzero(Count(
  Filter(Descendants([Xray Test].CurrentMember,[Xray Test].[Test]),
  (Order(
    Filter(Descendants([Xray Test Execution].CurrentMember,
           [Xray Test Execution].[Execution]),
      [Measures].[Xray Tests executed]>0
    ),
    [Measures].[Xray Test Execution End Date],
    BASC).Item(0),
  [Measures].[Xray Tests executed],
  [Xray Test Run Status].[PASSED])>0
  )
))

Kindly,
Janis, eazyBI support