How to calculate "remaining estimated hours change" for completed issues in a sprint using tuple instead of sets as below?

Questions & Answers
,
1

0-Sum(
Filter(
Descendants([Issue].Currentmember, [Issue].[Issue]),
Aggregate({
[Transition Status].[Done]
},
[Measures].[Sprint issues at closing]
)>0
),
(
[Measures].[Remaining estimated hours change],
[Transition Field].[(none)],
[Sprint Status].[Active],
[Time].Currenthierarchy.Defaultmember,
[Sprint].CurrentHierarchyMember,
[Logged by].DefaultMember
)
)

2

Hi @dhruvdhingra1,

Unfortunately, combining the two requirements (completed in a specific Sprint and total remaining estimated hours change) is not possible in a tuple. You can optimize the formula to return results faster, but it still must iterate through issues. The report context may help improve the formula, so consider sharing the report definition - Export and import report definitions.
See the suggested formula below:

0
-
Sum(
  Filter(
    Descendants([Issue].Currentmember, [Issue].[Issue]),
    Not IsEmpty([Issue].CurrentHierarchyMember.get('Sprint ID'))
    AND
    ([Transition Status].[Done],
    [Measures].[Sprint issues at closing])>0
  ),
  (
    [Measures].[Remaining estimated hours change],
    [Time].Currenthierarchy.Defaultmember,
    [Sprint].CurrentHierarchyMember,
    [Logged by].DefaultMember
  )
)

Best,
Roberts // support@eazybi.com

3

Thanks, Roberts!

It is still not that fast. Can we not use Transition dimension somehow? I have been trying but I do no think I have been able to understand the dimension completely.

4

Hi @dhruvdhingra1,

The Transition Status dimension helps the measure “Sprint issues at closing” determine which issues were “Done” when the Sprint completed. Otherwise, it would include all issues in the Sprint at the time of closing. The eazyBI documentation page has more details on the dimension itself - Import issue change history.

I can’t help you further without more details about the report. So please share the report definition here or via the support email with reference to this community thread.

Best,
Roberts // support@eazybi.com