Hi I am looking for an Eazy bi solution to show the efficiency of fixing defects and fixing it first time.
[(number of Resolved Defects) – (number of Reopened Defects)] / (number of Resolved Defects) – represented as a percentage.
Any help on how to create a report for this would be great.
Hi @Dilan,
The approach depends on how you determine “Reopened Defects”. For the sake of an example, I presume those are issues whose resolution changes to Unresolved. In such a scenario, the calculated measure formula could look similar to the one below:
( -- resolved Bugs ([Measures].[Issues resolved], [Issue Type].[Bug]) - -- reopened bugs ([Measures].[Transitions to issues count], [Issue Type].[Bug], [Transition Field].[Resolution], [Resolution].[(unresolved)]) ) / ([Measures].[Issues resolved], [Issue Type].[Bug])
See more details on defining calculated measures here - Calculated measures and members.
Best, Roberts // support@eazybi.com