Defect Density Chart for Projects

I have been using EzyBI For some time now,

i have task to created Defect density chart for projects,

Could you guide where i can find the right metrics to get the (Defect Density output)?

1 Like

Hi @shiva,
Welcome to the eazyBI community!

One of the ways how to calculate Defect density is to look on how many bugs have been created versus all Issues resolved.
To create this report you need to create a calculated measure Bugs created.

([Measures].[Issues created], [Issue Type].[Bug])

Then byusing this measure you can calculate Defect density:

CASE WHEN
[Measures].[Issues resolved] > 0
THEN
[Measures].[Bugs created] / [Measures].[Issues resolved]
END

The end report could look like this:

best,
Gerda // support@eazybi.com

Thanks , that worked after few tweeks.

1 Like