On eazyBI evaluation period: Request for support on a customised report

[daina.tupule]

eazyBI does not have default measures for allocation plan. However, here is an example formula you can use for this. The formula below will calculate estimation per period for Original estimated hours between two dates - start date and end date:

CASE WHEN 
-- show for default time periods on workingdays only
([Time].CurrentHierarchyMember.Level.Name = "Day" 
  and 
 NOT CoalesceEmpty([Time].CurrentHierarchyMember.Get("Week day name"),"") MATCHES "Saturday|Sunday")
 or [Time].CurrentHierarchyMember.Level.Name MATCHES "Year|Week|Month|Quarter"
 or [Time].CurrentHierarchyMember is [Time].CurrentHierarchy.DefaultMember
THEN
NonZero(SUM(
  Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]),
  -- check if an issue has start and end date, and it falls into selected period:
  NOT IsEmpty([Measures].[Issue Start date])
  AND
  NOT IsEmpty([Measures].[Issue End date])
  AND
  (DateBetween(
    [Time].CurrentHierarchyMember.StartDate,
    [Measures].[Issue Start date],
    [Measures].[Issue End date])
    OR 
  DateInPeriod(
    [Measures].[Issue Start date], 
    [Time].CurrentHierarchyMember)
  )),
  -- total planned time
  ([Measures].[Original estimated hours],
  [Time].CurrentHierarchy.DefaultMember)
  /
  -- total count of workdays in planned period between start date and end date
  DateDiffWorkdays(
    [Measures].[Issue Start date],
    DateAddDays([Measures].[Issue End date],1)
  )
  *
   -- days per period 
   DateDiffWorkdays(
     TimestampToDate(IIF(DateInPeriod([Measures].[Issue Start date], [Time].CurrentHierarchyMember), 
       DateToTimestamp(DateWithoutTime([Measures].[Issue Start date])),
       DateToTimestamp([Time].CurrentHierarchyMember.StartDate))),
     TimestampToDate(IIF(DateInPeriod([Measures].[Issue End date], [Time].CurrentHierarchyMember), 
       DateToTimestamp(DateAddDays([Measures].[Issue End date],1)),
       DateToTimestamp([Time].CurrentHierarchyMember.NextStartDate)))
   )
))
END

Here I created a measure Estimates with the formula above and used it in the report and split (drill into) it’s values per month.

Daina / support@eazybi.com