Get total issues from multiple sprints

Hi Guys,
I am trying to add together the issues committed to and completed in the last 2 sprints (not the current sprint). I have looked all over this forum for a solution but everything seems to be based on a single sprint.

Hi @JohnB

To calculate the total sprint issues committed for previous 2 closed sprints you can create a calcualted measure using this formula:

CASE
  WHEN
    [Sprint].CurrentHierarchyMember.Level.Name = 'Sprint' AND
    [Sprint].CurrentHierarchyMember.GetBoolean('Closed')
  THEN
  Sum(
    Tail(
      Filter(
        -- filter last 5 previous sprints in a board starting from current sprint
        [Sprint].CurrentHierarchyMember.FirstSibling:
        [Sprint].CurrentHierarchyMember,
        [Sprint].CurrentHierarchyMember.GetBoolean('Closed')
      ),
      -- set the count of last closed sprints for running velocity
      2 ) ,
    [Measures].[Sprint issues committed]
  )
END

See some report examples on our public demo account: Sprints Overview - Jira Demo - eazyBI

Please read this documentation page on different sprint scope measures in eazyBI:
https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-software-custom-fields#JiraSoftwarecustomfields-Sprintscopemeasures

Martins / eazyBI