Time logged during sprint


#1

I am working on a report to show the hours logged during a sprint. I found this answer which is almost what I want, with two changes.

  1. I’d like it to report time logged during the sprint even if the issue was added to the sprint later. Right now it is excluding worklogs that were logged after the sprint was open, but before an issue was added to it.

  2. I’d like to be able to drill through the worklogs like I can if I use the “Tempo billed hours” measure. Is it possible to do this with calculated measures?

Thanks!


#2

Hi Majken,

Yes, you are right, the two formulas provided in the linked thread take into account if the issue was part of the sprint while the hours were logged. To calculate Hours spent during Sprint time for issues that have ever been part of that Sprint, ignoring if they were part of the Sprint when the hours were logged, please try the following calculated Measure

NonZero(SUM(Filter(
  Descendants([Issue].CurrentMember, [Issue].[Issue]),
  ([Measures].[Transitions to],
   [Time].CurrentHierarchy.DefaultMember) > 0),
  SUM(
  Filter(Descendants([Time].CurrentMember, [Time].[Day]), 
    [Measures].[Time within Sprint] > 0 ),
     NonZero (([Measures].[Hours spent],
       [Issue].CurrentMember,
       [Sprint].DefaultMember))
  )
))

Lauma / support@eazybi.com