Total time spent of issues within sprint

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!

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

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

Thanks - it’s working as intended!

1 Like

I implemented Total Hours Spent as mentioned:
Sum(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
[Measures].[Sprint issues completed] > 0
), ([Measures].[Hours spent],[Sprint].CurrentHierarchy.DefaultMember)
)

But in my report I have issues showing up that have no data even though they show Hours Spent in the sprint. Why would that be?

image

Hi @EdP,

The calculated measure considers issues that were completed in the particular Sprint. The condition on the measure “Sprint issues completed” [Measures].[Sprint issues completed] > 0 ensures that.
So, it could be that work was logged for a particular issue (showing up in “Hours spent”), but the issue was not completed in the specific Sprint. Thus, the calculated measure returns empty.

You can alter the condition inside the Filter() function to adjust the calculation for your requirement. See more details about the Filter() function - Filter.

Best,
Roberts // support@eazybi.com