List of last 6 sprints on a specific Board

Questions & Answers
, , , ,
2

Hi @Kunal_Kumar,

If you are looking for only one particular Board sprints, you can hardcode this within the last 6 sprint calculation. For example:

Aggregate(
  Tail(Order(
    Filter(ChildrenSet([Sprint].[BOARD_NAME]),
      [Sprint].CurrentHierarchyMember.getBoolean('Closed') AND
      NOT IsEmpty([Sprint].CurrentHierarchyMember.get('Complete date'))),
    [Sprint].CurrentHierarchyMember.get('Start date'),
    BASC
  ), 6)
)

If you would like to return only the last six sprints from any board, you can look at creating a new hierarchy in the Sprint dimension by importing an additional property to Sprint - Board name only to the last six closed sprints. Please see a similar example here Restrict sprint within board - #2 by lauma.cirule.

Lauma / support@eazybi.com