Total time spent of issues within sprint

Questions & Answers
,
1

I would like to see total hours spent for all the issues within sprint. Some of the issues span multiple sprints so when looking at the sprint in which the issue was closed, I’d like to see all hours spent on this issue, not only the hours spent within the last sprint.

Thanks in advance!

2

Bumping this question - still needing help about this topic. :slightly_smiling_face:

3

Hi @JurgenT,

To get the total number of “Hours spent” from issues in the Sprint they were closed, try creating a new calculated measure with the formula below:

Sum(
  Filter(
    Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
    [Measures].[Sprint issues completed] > 0
  ), ([Measures].[Hours spent],[Sprint].CurrentHierarchy.DefaultMember)
)

It will get all the issues that were completed in the current Sprint and sum up the “Hours spent” in those issues disregarding the current Sprint.

Visit the eazyBI documentation page for more information on calculated measures - https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members.

Best,
Roberts // support@eazybi.com

4

Thanks - it’s working as intended!

1 Like