Project Level Total


#1

Hi,

Question on why the column “Total Days on Hold” does not add all values. On the example below the project total is just 40 and seems like it just computes for “Completed” epics. The formula computes for how many days an epic was on hold, the formula definition is…

CASE WHEN [Status].[Status].GetMemberNameByKey([Issue].CurrentHierarchyMember.Get('Status ID')) = "On Hold" THEN
       Aggregate([Transition Status].[On Hold], [Measures].[Days in transition status])
         + DateDiffDays([Measures].[Transition to status last date], Now())
     ELSE
       Aggregate([Transition Status].[On Hold], [Measures].[Days in transition status])
     END

Thanks!


#2

Hi,

The formula you are using is performing on each line the CASE statement and there is no part that says there should be a Sum of lower level values. On the Project level this goes into ELSE brunch taking, as you noticed, only the Days in On Hold status for all issues in the Project.

To do the sum, please try the following formula

Sum(
  Filter(Descendants(
      [Issue].CurrentMember, [Issue].[Issue]),
    [Measures].[Issues created] > 0
  ),
  CASE WHEN [Status].[Status].GetMemberNameByKey([Issue].CurrentHierarchyMember.Get('Status ID')) = "On Hold" THEN
     ([Transition Status].[On Hold], [Measures].[Days in transition status])
       + DateDiffDays([Measures].[Transition to status last date], Now())
  ELSE
     ([Transition Status].[On Hold], [Measures].[Days in transition status])
   END
)

Lauma / support@eazybi.com