Issue counts based on timelines with respect to version release date

Questions & Answers
#1

Hi All,

I am trying to find out a way to execute the below conditions from Jira tool to EazyBI.

Bugs discovered during release development
Condition: Count of bugs when issue created date <= release date

Bugs Resolved before the release date
Condition: Count of bugs when status = done and issue resolved date <= release date

Bugs reported within 90 days after the release date
Condition:
Count of bugs when issue created date >= release date and issue created date <= 90 days from release date and issue resolved date <= release date and resolution not in [(Rejected,“Cannot Reproduce”,Declined,Duplicate) or resolution = Unresolved]

image

#2

Hi,

It is possible to create custom calculations for the issue counts, as you described. Note that the measures for those use cases require the use of constructions that have a risk of performance problems.

I assume that your report should also have the Fix version dimension, and you will be able to select a version from the report pages to have the report by Products related to the selected version.

The formulas for your measures would be the following:

  1. Bugs discovered during the release:

    NonZero(Count(
    Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
    DateBetween([Measures].[Issue created date],
    [Measures].[Version start date],[Measures].[Version release date])
    AND
    ([Measures].[Issues created],
    [Issue Type].[Bug])>0
    )
    ))

  2. Bugs reported and resolved during release and in status Done:

    NonZero(Count(
    Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
    DateBetween([Measures].[Issue created date],
    [Measures].[Version start date],[Measures].[Version release date])
    AND
    DateCompare([Measures].[Issue resolution date],
    [Measures].[Version release date])<0
    AND
    ([Measures].[Issues created],
    [Status].[Done],
    [Issue Type].[Bug])>0
    )
    ))

  3. Bugs reported within 90 days after the release:

    NonZero(Count(
    Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
    DateDiffDays([Measures].[Version release date],
    [Measures].[Issue created date])<90
    AND
    DateDiffDays([Measures].[Version release date],
    [Measures].[Issue created date])>0
    AND
    ([Measures].[Issues created],
    [Resolution].[Real bug],
    [Issue Type].[Bug]
    )>0
    )
    ))

Note that the last formula refers to the aggregated member in the Resolution dimension and expects that there is a custom calculated member in the Resolution dimension with the formula like this:

Aggregate(
  Except(
    [Resolution].[Resolution].Members,
    {
    [Resolution].[Rejected],
    [Resolution].[Cannot Reproduce],
    [Resolution].[Declined],
    [Resolution].[Duplicate]
    }
  )
)

The report with those measures could look like this:

image
image1664×706 54.9 KB

Kindly,
Janis, eazyBI support