Unique / Distinct Defect Count in Zephyr

Questions & Answers
1

I have a report which shows the number of tests executed and the test defect count for each test cycle using the Measures ‘Zephyr Tests executed’ and ‘Zephyr Tests defect count’. The issue I have is that within a test cycle a single defect can be attached to multiple test cases therefore making the defect count in the report higher than it actually is. Is there a calculated measure for ‘Unique/Distinct defect count’ in a test cycle or can I make my own?

2

Hi,

Right, the defect count is multiplied by the number of test cases attached.

You can create your custom distinct defect count with the following formula:

NonZero(Count(
Filter(
Descendants([Zephyr Defect].CurrentHierarchyMember,[Zephyr Defect].[Defect]),
[Measures].[Zephyr Tests defect count] > 0 )
))

Kindly,
Janis, eazyBI support

3

Hello, I would like to be able to know with that code you have, if you can only show those that are in “To Be” status, to identify those that are still under review. Thanks

4

Hi,

The formula can be extended to count the defects with specific status:

NonZero(Count(
   Filter(
     Descendants([Zephyr Squad Defect].CurrentHierarchyMember,[Zephyr Squad Defect].[Defect]),
     [Measures].[Zephyr Squad Tests defect count] > 0 
   AND
  [Status].[Status].GetMemberNameByKey(
     [Zephyr Squad Defect].CurrentMember.get('Status ID')  
  )="To Do"
)
))

Kindly,
Janis, eazyBI support