Issues created before/after version release & Time dimension

[Rolandas K]

Hello,

I’m trying to create report which shows Defect Detection rate for each Jira project. The report relies on [Affects Version] dimension and categorizes Defects comparing their creation date vs version release date.

Sample report example below:

Calculated measures:

1. Defects created:
   ( [Measures].[Issues created], [Issue Type].[Defect], [Resolution].[Unresolved or Fixed])

2. Defects created before version release:
   Sum(
   Descendants([Affects Version].CurrentMember, [Affects Version].[Version]),
   Sum( Generate(Ascendants(
   [Time].CurrentHierarchy.Levels(‘Day’).DateMember(
   [Affects Version].CurrentHierarchyMember.get(‘Release date’))
   ),
   IIF([Time].CurrentHierarchyMember IS
   [Time].CurrentHierarchyMember.FirstSibling, {},
   { [Time].CurrentHierarchyMember.FirstSibling:
   [Time].CurrentHierarchyMember.PrevMember })
   ),
   [Measures].[Defects created]
   ))

3. Defects created after version release:
   Sum(
   Descendants([Affects Version].CurrentMember, [Affects Version].[Version]),
   Sum(Generate(Ascendants(
   [Time].CurrentHierarchy.Levels(‘Day’).DateMember(
   [Affects Version].CurrentHierarchyMember.get(‘Release date’))
   ),
   IIF([Time].CurrentHierarchyMember IS
   [Time].CurrentHierarchyMember.LastSibling, {},
   { IIF([Time].CurrentHierarchyMember.Level.Name = ‘Day’,
   [Time].CurrentHierarchyMember,
   [Time].CurrentHierarchyMember.NextMember):
   [Time].CurrentHierarchyMember.LastSibling })
   ),
   [Measures].[Defects created]
   ))

4. Defect detection rate:
   CASE WHEN [Measures].[Defects in version count] > 0
   THEN [Measures].[Defects created before version release]
   / [Measures].[Defects in version count]
   END

5. Defects in version count:
   [Measures].[Defects created before version release] + [Measures].[Defects created after version release]

PROBLEM:
The measures seem to calculate their job correctly until I add [Time] dimension in [Pages]. You can see in the image above, that when [Last 30 days] is selected - measures [Defects created before version release] and [Defects created after version release] do not react to it and still show all Defects that fall under All times category.

Can someone help me adjust the measures, so that they take [Time] into account? Or, come up with different measures or report format to track Defect Detection rate for each Project over time. It should analyze Defects created in each Project for a period. If Defect’s creation date is earlier than Affects version’s release date (each issue has such field as mandatory), than it is a prior-release defect. Otherwise, if Defect’s creation date is equal or later than Affects version’s release date, then it is post-release defect.

Thank you in advance.

[Gerda Grantiņa]

Hi @Rolandas K
I noticed this unanswered question for eazyBI. But I see that you got your answer on the eazyBI Community page, so I will post a link to the answer here in case someone else is looking for a similar question: https://community.eazybi.com/t/issues-created-before-after-version-release-time-dimension/3529/6

best, 
Gerda // support@eazyBI.com