Issues created before/after version release & Time dimension

Questions & Answers
3

You are using a formula that overrides (ignores) Time selection in the report.

The first formula addresses any time before a version release date and the second formula address any time for any version after version release date.

Both formulas work on time hierarchy default structures. The first formula is the older version (exact formula) of eazyBI function PreviousPeriods. You used the same approach to create a formula to retrieve next periods (we do not have the function for this).

However, in your case, you would like to pull in the selected period and split the period in days till version release and after version release.
I added an additional case to the formula to add all created issues to a period if the version was released after the selected period. This is a performance improvement in the formula, to avoid cases when we unnecessary validate any period with any version.

Here is a possible formula for Issues created in the period till version release:

Sum(
Descendants([Affects Version].CurrentMember, [Affects Version].[Version]),
  CASE WHEN
  -- for version releaed in period we will split issues created
  DateInPeriod(
    [Measures].[Version release date],
    [Time].CurrentHierarchyMember
  )
  THEN
  SUM(
    Filter(
      -- get all days in selected period
      Generate( 
        { [Time].CurrentHierarchyMember,
        ChildrenSet([Time].CurrentHierarchyMember) },
        Descendants([Time].CurrentHierarchyMember,[Time].CurrentHierarchy.Levels("Day"))),  
     -- filter by days till version release:
     DateCompare(
       [Time].CurrentHierarchyMember.StartDate,
       [Measures].[Version release date]
     ) <=0),
  [Measures].[Defects created])
  WHEN
  -- for a period before version release date we will assign all created issues
  DateCompare(
    Cache(Generate( 
    { [Time].CurrentHierarchyMember,
    ChildrenSet([Time].CurrentHierarchyMember) },
    Descendants([Time].CurrentHierarchyMember,[Time].CurrentHierarchy.Levels("Day"))).Item(0).StartDate),
    [Measures].[Version release date]) <=0
  THEN NonZero([Measures].[Defects created])
  END
)

You can use a similar formula changing the comparison that will count issues created after a version release date.

Daina / support@eazybi.com