Sum of issues added to sprint by number of days

Questions & Answers
1

Hello,

I have a bunch of nice reports and we have discovered quite huge ratio of issues added into sprint. What I would like to achieve is to see the total count of issues added into sprint 1st day after start, 2nd day, 3rd day etc… in total of sprints closed in last 12 weeks.

To specify closed sprints in last 12 weeks there is no issue:

Aggregate(
  Order(
    Filter([Sprint].[Sprint].Members,
      [Sprint].CurrentMember.getBoolean('Closed') AND
      NOT IsEmpty([Sprint].CurrentMember.get('Complete date')) AND
      DateBetween([Sprint].CurrentMember.get('Complete date'),
        '12 weeks ago',
        'today') ),
    [Sprint].CurrentMember.get('Complete date'),
    BASC
  )
)

But I am actually lost of the specification how to calculate dynamically the sum of issues per days after the sprint started.

Please, does anyone has experience or would anyone be so kind and give me a hint?

2

Hi @Jakub,
You can create a report that shows on Timeline when the Sprints started with this formula “Sprints in Time”:

Generate(Filter( 
  [Sprint].[Sprint].Members,
  IIF (
  DateInPeriod(
    [Sprint].CurrentMember.get('Start date'),
      [Time].CurrentHierarchyMember
    ) , 
    ([Time].CurrentHierarchy.DefaultMember,
      [Measures].[Sprint issues committed]) ,0) > 0),
  -- show sprint name
  [Sprint].CurrentMember.Name,
  ', '
)

Filter you report Rows by “Time within multiple Sprints”>0:

CASE WHEN
  Sum(Descendants(
    {[Sprint].CurrentMember,
       ChildrenSet([Sprint].CurrentMember)},
      [Sprint].[Sprint]),
  --ChildrenSet([Sprint].CurrentMember),
    CASE WHEN DateBetween([Time].CurrentHierarchyMember.StartDate,
      DateAddDays([Sprint].CurrentMember.get('Start date'), -1),
      [Sprint].CurrentMember.get('Complete date')
    ) THEN NonZero(([Measures].[Issues created],[Time].CurrentHierarchy.DefaultMember)) END
  ) > 0
THEN 1
END

Also, you can change you aggreggate to filter Sprint by “Start date”.
Then add in the report measure “Sprint issues added” and then you can set the first measure “Sprints in Time” as vertical lines and remove “Time within multiple Sprints” (so only filter is applied). The report would look like this then:

Sprint_issues_added_-Issues-Jira_reports-_eazyBI
Sprint_issues_added_-Issues-Jira_reports-_eazyBI1920×684 82 KB

best,
Gerda // support@eazyBI.com