Calculating Defect Escape Rate - Need a custom Measure that counts production environment Bugs

Questions & Answers
,
1

Hi,

I’m looking to create a Defect Escape Rate Report.

We use a custom field called Environment for our Bug IssueType that allows us to know if the bug was a Production bug or one found in a test or stage environment. We also use the Defect sub-task and these are always considered Non Production bugs for us.

I’m struggling to figure out how to create a measure for Production Bugs so that I can include it in the calculation of the Defect Escape Rate formula which I’m defining as-

Production Bugs / (All Bugs + All Defects)

For example, if there are 10 total bugs & defects and 2 are Bugs where the Environment field = Production, then my formula should return a 20% Defect Escape Rate

I’m able to get the simple part figure out below, but not sure how to leverage the environment field in my calculation.

CASE WHEN ([Issue Type].[Defect],[Measures].[Issues created]) > 0
THEN
([Issue Type].[Bug],[Measures].[Issues created])
/
(([Issue Type].[Defect],[Measures].[Issues created]) +
([Issue Type].[Bug],[Measures].[Issues created]))
END

Any help would be greatly appreciated, thanks!

2

Hi,

Assuming that you have imported the Environment field as a dimension, you can extend the tuple to count the bugs from the production environment:

CASE WHEN ([Issue Type].[Defect],[Measures].[Issues created]) > 0
THEN
([Issue Type].[Bug],[Measures].[Issues created],[Environment].[Production])
/
(([Issue Type].[Defect],[Measures].[Issues created]) +
([Issue Type].[Bug],[Measures].[Issues created]))
END

Kindly,
Janis, eazyBI support

1 Like
3

Thank you. This works in the calculation and returns the expected results.

1 Like