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
