Show open errors per cycle in TO DO state

Questions & Answers
1

Hello,

I’m looking for a solution to be able to view my open bugs in a test cycle but have them only be in the “To Be” state. Currently I can only present all the reported errors regardless of the status they are in.

I currently use the following code which shows me all the open errors in the Test Cycle.
“Count(
Filter(
Descendants([Zephyr Squad Defect].CurrentHierarchyMember,[Zephyr Squad Defect].[Defect]),
[Measures].[Zephyr Squad Tests defect count] > 0
)
)”

But as indicated in other comments, this code brings all the open errors that are related to a test case, but I need it to only bring those that are in the “To be” state associated with a test case of a test cycle

2

Hi @ctapiat

Welcome to the Community!

You are close with your formula!
The Status of the defect is stored in the Issue dimension, so, for each defect, you can switch to the issue dimension to retrieve the Status ID and then switch to the Status dimension to get the name and compare it to “To Do”.

Here’s the formula for this:

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

​Best regards,
​Nauris