Logged hours per sprint

[Miroslav Kralik]

I have the following formula to show logged hours per sprint:

Aggregate({
  Generate(Filter(NonEmptyCrossJoin(
      Descendants([Sprint].CurrentMember, [Sprint].[Sprint]),
        [Measures].DefaultMember),
    [Sprint].CurrentMember.Name MATCHES '^Backend.*'), 
  [Sprint].[Sprint].CurrentMember )
})

The problem is that it is considering all the issues on the sprint but not the logged hours between the startime of the sprint to the endtime of the sprint.

I want to check how many hours the team logged into each sprint.

How to achieve this? 

Thanks, MIro

[Durgesh Gupta]

Hi Miroslav,

There is this amazing plugin which I think will perfectly suit your needs and resolve your issues....Click on the link below to check it out!

Organize - Capacity Planner

You can find the functionality details in the following video: https://youtu.be/pjBWzJwkhIo