First Time Fix Ratio

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