Hour spent in sprint for logged by users

Questions & Answers
1

am working on a report to show the hours logged during a sprint. I’d like it to report time logged during the sprint even if the issue was added to the sprint later
I found this in eazy bi community
image
but it show’s total amount I want to see it through logged by . The picture below

image
image847×383 36.1 KB

all rows are empty can any one help me?

2

@lauma.cirule
I’d be more than happy if you help me

3

Hi @sepehrp,

By default, the measure “Hours spent” shows logged hours only for issues that were in the sprint at the time. If you would like to get all logged hours of issues that were committed or added later to the sprint, then you can create a calculated measure.

The structure for the calculation would be similar. You should iterate through individual issues and sum up logged hours for each during the sprint period. The main difference is the filter criteria for the Filter() function and the CASE WHEN condition. Use the Sprint scope measures “Sprint issues committed”, “Sprint issues added”, and “Sprint issues removed” to check if an issue was in the sprint until the end.

The updated expression might look like this:

Sum(
  --set of issue that were commited or added to spint
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    --issue has been in selected sprint
    Cast([Sprint].CurrentHierarchyMember.KEY as STRING) MATCHES 
      Replace([Issue].CurrentMember.Get('Sprint IDs'),",","|")
  ),
  CASE WHEN --issue is commited or added later to sprint and was not removed
    ([Measures].[Sprint issues committed],
    [Time].CurrentHierarchy.DefaultMember)
    +
    ([Measures].[Sprint issues added],
    [Time].CurrentHierarchy.DefaultMember)
    -
    ([Measures].[Sprint issues removed],
    [Time].CurrentHierarchy.DefaultMember) 
    > 0
  THEN --sum up logged hours during the sprint
    Sum(
      --period from sprint start till end or today for active sprints
      [Time].[Day].DateMembersBetween(
        [Sprint].CurrentHierarchyMember.Get('Activated date'),
        CoalesceEmpty([Sprint].CurrentHierarchyMember.Get('Complete date'),"today")
      ),
      --logged hours regardles of sprint asociated with issue
      ([Measures].[Hours spent],
      [Sprint].CurrentHierarchy.DefaultMember)
    )
  END
)

More details on calcauted measures are described in the documentation: Calculated measures
Here is the description of Sprint scope measures: Jira Software custom fields

Best,
Zane / support@eazyBI.com