Total estimated hours

Questions & Answers
1

Hi everyone, I’m working on a report to compile all estimated hours for this year. However, there are some issues created in the past year that extend into this year. If I filter by pending issues, I am not obtaining the total estimated hours but only the remaining hours. Conversely, if I filter by year, the issues created last year are not within the scope. I need to include all issues created this year and those with an end date after December 31, 2023 to get the real estimeted hours

2

Hi @Viol1914,

By default, the “Original estimated hours” measure is tied to the Time dimension by the issue creation date. So, if you filter the report by the year 2024, issues created in 2023 will be discarded. To add the issues created in 2023, but their end date is in the currently selected year, you can try defining a calculated measure similar to the one below:

[Measures].[Original estimated hours]
+
Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    DateInPeriod(
      [Issue].CurrentMember.Get('Program End'), -- change date property name here
      [Time].CurrentHierarchyMember
    )
  ),
  -- issue created in previous periods
  CASE WHEN
    DateBeforePeriodEnd(
      [Issue].CurrentMember.Get('Created at'),
      [Time].CurrentHierarchyMember.PrevMember
    )
  THEN
    NonZero(([Measures].[Original estimated hours],
    [Time].CurrentHierarchy.DefaultMember))
  END
)

Please look at our documentation page for more information on defining calculated measures - ​Calculated measures and members.

Best,
Roberts // support@eazybi.com