# Total time spent of issues within sprint

**URL:** <https://community.eazybi.com/t/total-time-spent-of-issues-within-sprint/3763>\
**Category:** Questions & Answers\
**Tags:** sprints, sprint\
**Created:** [February 19, 2020, 6:23am UTC](https://community.eazybi.com/t/total-time-spent-of-issues-within-sprint/3763 "2020-02-19T06:23:36Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![JurgenT](https://community.eazybi.com/letter_avatar_proxy/v4/letter/j/858c86/32.png) [@JurgenT](https://community.eazybi.com/u/JurgenT)\
**Post date:** [February 19, 2020, 6:23am UTC](https://community.eazybi.com/t/total-time-spent-of-issues-within-sprint/3763/1 "2020-02-19T06:23:36Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![JurgenT](https://community.eazybi.com/letter_avatar_proxy/v4/letter/j/858c86/32.png) [@JurgenT](https://community.eazybi.com/u/JurgenT)\
**Post date:** [February 25, 2020, 9:02am UTC](https://community.eazybi.com/t/total-time-spent-of-issues-within-sprint/3763/2 "2020-02-25T09:02:14Z")

</div>

Bumping this question - still needing help about this topic. 🙂

---

<div class="post-metadata">

**Author:** ![roberts.cacus](https://community.eazybi.com/user_avatar/community.eazybi.com/roberts.cacus/32/637_2.png) [@roberts.cacus](https://community.eazybi.com/u/roberts.cacus)\
**Post date:** [February 26, 2020, 10:06am UTC](https://community.eazybi.com/t/total-time-spent-of-issues-within-sprint/3763/3 "2020-02-26T10:06:15Z")

</div>

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](https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members).

Best,  
Roberts // [support@eazybi.com](mailto:support@eazybi.com)

---

<div class="post-metadata">

**Author:** ![JurgenT](https://community.eazybi.com/letter_avatar_proxy/v4/letter/j/858c86/32.png) [@JurgenT](https://community.eazybi.com/u/JurgenT)\
**Post date:** [February 28, 2020, 10:38am UTC](https://community.eazybi.com/t/total-time-spent-of-issues-within-sprint/3763/4 "2020-02-28T10:38:47Z")

</div>

Thanks - it’s working as intended!

---

<div class="post-metadata">

**Author:** ![EdP](https://community.eazybi.com/letter_avatar_proxy/v4/letter/e/ea5d25/32.png) [@EdP](https://community.eazybi.com/u/EdP)\
**Post date:** [April 6, 2023, 4:26pm UTC](https://community.eazybi.com/t/total-time-spent-of-issues-within-sprint/3763/5 "2023-04-06T16:26:43Z")

</div>

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](https://community.eazybi.com/uploads/default/original/2X/f/fc19732743b2ebbbe8093be25d8bd213624c51c8.png)

---

<div class="post-metadata">

**Author:** ![roberts.cacus](https://community.eazybi.com/user_avatar/community.eazybi.com/roberts.cacus/32/637_2.png) [@roberts.cacus](https://community.eazybi.com/u/roberts.cacus)\
**Post date:** [May 2, 2023, 1:30pm UTC](https://community.eazybi.com/t/total-time-spent-of-issues-within-sprint/3763/6 "2023-05-02T13:30:14Z")

</div>

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](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/filter).

Best,  
Roberts // [support@eazybi.com](mailto:support@eazybi.com)