How to fetch count of different IssueTypes [Defect Rate]

Questions & Answers
, ,
#1

Hi All,

i want to calculate Defect Rate and the formula is as below

** Total no of Defects (Excluding Rejected) / Total Test Cases Executed **

Has anyone tried doing this, would be more helpful.

Also, How to get the count of IssueType = Test OR Bug separately ? Also any way to get them with only intended conditions (like Bug only closed, Tests only Executed (pass/fail))

Thanks

#2

Hi @prakashghiremath ,

You can use the Defect and Test execution measures to calculate the defect rate. See an example below with measures from the Xray integration:

CASE WHEN [Measures].[Xray Tests executed] > 0
THEN 
  [Measures].[Xray Tests defect count]
  /
  [Measures].[Xray Tests executed]
END

The report could look similar to the one below:

Screenshot 2021-02-24 at 12.08.13
Screenshot 2021-02-24 at 12.08.131246×804 61.5 KB

See if the test management app you are using has integration with eazyBI - Data from Jira and apps - eazyBI for Jira. From there, you can see the measures imported by the apps eazyBI has integration.

Best,
Roberts // support@eazybi.com