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:
- 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
)
))
- 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
)
))
- 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