Count bugs which opened after epic moved to status done

Hello,

I am looking for solution to create a report which presents the escaped bugs.
Escaped means bugs that opened after the Epic (parent) moved to the status “preprod”.
I would like to count these bugs each sprint.

I am using the measure " transition to status first date" but need to compare this date to the bug’s created date.

How to compare the Bug created date to the first date in which his parent move to status “preprod” ?
How to count the escaped bugs?

Thanks in advance,
Idan.

Hi @Idan_Malul

Welcome to the eazyBI community.

In your case, you would need to create a new user-defined calculated measure that counts issues with issue type bug (which also have an epic) created after their epics went to the specific status.
Try this formula.

NonZero(
Count(
Filter(
Descendants([Issue.Epic].CurrentHierarchyMember,[Issue.Epic].[Parent]),
[Measures].[Issue type] = "Bug"
AND
Not IsEmpty([Issue].CurrentHierarchyMember.get('Epic Link'))
AND
Datecompare(
  [Issue].CurrentHierarchyMember.get('Created at'),
  (
    [Issue].CurrentHierarchyMember.Parent,
    [Measures].[Transition to status first date],  
    [Transition Status].[Preprod] --make sure that Preprod status is imported in eazyBI
  )
)>0
AND
[Measures].[Issues created]>0
)
)
)

Martins / eazyBI team