Calculate only Hours Spent of completed items in a Sprint

Questions & Answers
1

We have the “Hours Spent” in a sprint on the items included
but we want to have also “Hours Spent” of “Completed” items only.

What is the way to do it? (hopefully possible within the same report)

image
image1118×220 13.1 KB

2

Yes, you are correct. Measure Hours spent represents the total time spent on the issue while in sprint no matter if the issue was completed in the sprint or not.

Here is an example formula pulling in logged time from completed issues only. It iterates through all issues of the sprint and retrieves the total logged time during the sprint.

NonZero(SUM(
  Filter(
    Descendants([Issue].Currentmember, [Issue].[Issue]),
    IIF ([Sprint].CurrentHierarchyMember is [Sprint].CurrentHierarchy.DefaultMember, 1,
    -- validate if issue was in any sprint at completion      
    count(intersect(
    -- access a selection of sprints in the report
      DescendantsSet([Sprint].CurrentHierarchyMember, [Sprint].CurrentHierarchyMember.Levels("Sprint")),
      -- compare it to sprints of issue
        [Sprint].[Sprint].CurrentHierarchy.Levels('Sprint').GetMembersByKeys([Issue].CurrentMember.Get("Sprint IDs"))
      ))) > 0
    ),
    CASE WHEN
      [Measures].[Sprint issues completed] > 0
    THEN
      NonZero( [Measures].[Hours spent])
    END
))

Daina / support@eazybi.com

1 Like
3

Thank you very much for the support ! it seems to work (we are testing it)

4

hello @daina.tupule , is there a way to make the formula a little less memory demanding? I’m trying to use it but I get a lot of out of memory errors… and I’m calculating just a couple of sprints.