Report to show defects after a release

Questions & Answers
1

I need a report to show for a selected Affect version which are logged during the release and how many are fixed in the release (fix version - affect version) and which are logged after the version release.

A report import is welcome :slight_smile:

2

Hi @AlfredGieltjes,

To see the number of issues with the selected Affects version that were created while the version was active, I recommend defining a calculated measure with the formula below:

Sum(
  Filter(
    [Time].[Day].Members,
    DateBetween(
      [Time].CurrentMember.StartDate,
      [Measures].[Version start date],
      [Measures].[Version release date]
    )
  ),
  [Measures].[Issues created]
)

For issues created after the version was released, try the formula below:

Sum(
  Filter(
    [Time].[Day].Members,
    DateCompare(
      [Time].CurrentMember.StartDate,
      [Measures].[Version release date]
    ) > 0
  ),
  [Measures].[Issues created]
)

The report could look similar to the one below:

Screenshot 2023-05-03 at 11.08.13
Screenshot 2023-05-03 at 11.08.131560Ă—596 54.8 KB

For work logged, you can use the formulas, but instead of the measure “Issues created”, use “Hours spent”.

Please look at our documentation page for more information on defining calculated measures - ​Calculated measures and members.

Best,
Roberts // support@eazybi.com