Issue counts based on timelines with respect to version release date

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

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:

Kindly,
Janis, eazyBI support