I’m trying to create a calculated measure for issues with hours spent, but were not listed in the Sprint selected in the current page. Any help would be greatly appreciated.
This doesn’t work, but I’m trying:
[Sprint].CurrentMember.Name <> “(no sprint)”
Measure Hours spent should show logged time while the issue was added to the sprint.
The issue might have more logged time in total, though. If you would like to count total logged time for completed issues in a sprint, no matter when the time was logged on issue you can use this formula:
[Sprint].Currentmember.Level.name = "Sprint"
CoalesceEmpty([Measures].[Issue Sprint], "")
) MATCHES ".*"|| Cast([Sprint].CurrentMember.Key as string) ||".*"
([Measures].[transitions to], [Sprint Status].[Active]) > 0
If you would like to count total time logged in any issue during active sprint cycle (no matter if the time was logged in sprint or outside of sprint parallel to sprint cycle), you can check out this community topic:
Linking Non-Sprint Work to Sprint Based on Logged By and Date
Daina / email@example.com