Bugs reported within 90 days past the release date

Questions & Answers
, ,
1

Hi,

I would like to find out the total no. of bugs which were created within 90 days past the version release date.

Issue Type = Bug AND createdDate > 2020-01-01 and createdDate <= 2020-31-03

Note: This should not include bugs aging > 90 days (eg : Bug age = 100 days past the release date should not be included)

2

Hi,

The following custom measure counts the number of bugs reported for the version within the 90 days of the version release date:

Sum(
  [Time].[Day].DateMembersBetween(
    [Measures].[Version release date],
    DateAddDays([Measures].[Version release date],90)
  ),
  ([Measures].[Issues created],
  [Issue Type].[Bug])
)

This measure is designed to work with the Fix version dimension like this:

Kindly,
Janis, eazyBI support

3

Hey Janis,

Thanks a lot, it worked :slight_smile: