Can Someone help me to create report with number of bug created with specific label for story in each sprint

Questions & Answers
2

Hi, @Neeraj_Talreja

Welcom to the eazyBI community.

Are the bugs linked to the Soties? If so, please follow this article, to import the linked bugs: Linked bugs to issues

Also, we have a Demo report dedicated to the Linked Bugs: Stories with Bugs details - Issues - eazyBI Demo Training - eazyBI

Consider this report as a base for your report.

To find bugs with the label matches “Performance”, please use the following formula:

Case 
When
  [Issue].CurrentMember.Level.Name = "Issue"
  AND
  [Bugs].Currentmember is [Bugs].Defaultmember
Then
  -- retrieve Bugs information from Issue property Bugs
  Nonzero(Count(
    Filter(
      [Issue].CurrentHierarchy.GetLinkedmembers('Bugs'),
      CoalesceEmpty([Measures].[Issue labels], '') MATCHES  '.* Performance.*')
  ))
Else
 -- total calculation for any issue, data on Bugs level
  NonZero(Sum(
    Filter(
      DescendantsSet([Bugs].Currentmember, [Bugs].[Bugs]),
      CoalesceEmpty([Bugs].CurrentHierarchyMember.get('Labels'), '') MATCHES  '.* Performance.*'),
    [Measures].[Issues created]
 ))
End

About the sprints, please explain more. What type of information do you need? All sprints of the Story, current sprint?

Kindly,
Ilze

1 Like