Hello everyone hope you are doing well.
I have a sprint in that sprint I want to calculate total time estimation for that sprint and hours logged by a user in that sprint now the problem is some of the issues that are present inside the sprint but there logged hours are not shown when I used sprint on pages
Hi @Umar
It seems that some of these hours have been logged while the issue was not in the Sprint, this is why they show up in the (no sprint) section.
If the issues have only been in this one sprint, then you could use this following formula to find all hours logged to the Issues that have been committed or added to this Sprint at any point:
Sum(
Filter(
Descendants([Issue].CurrentMember,[Issue].[Issue]),
(
[Measures].[Sprint issues committed] > 0
OR
[Measures].[Sprint issues added] > 0
)
),
(
[Measures].[Hours spent],
[Sprint].CurrentHierarchy.DefaultMember
)
)
Please note that this will count the all the issue hours to all the Sprints that this issue has been in.
Let me know if this works as expected!
Best regards,
Nauris