Getting the last completed sprint by name, depending on page selection

[gerda.grantina]

Hello @cchase ,
I suggest using additional data mapping and then creating a Sprint custom hierarchy based on your Sprint name pattern. See the example here:

Combining different teams sprints into one

With version 6.1 we added a new to create custom hierarchies in some dimensions, including Sprints. You would like to import custom properties for sprints to represent a potential grouping mechanism. For example, you can import a property cycle for Sprints with additional data import. Then you can use this custom property Cycle to build a new custom hierarchy in Sprint dimension and group sprints by cycles dynamically. Import additional property to Sprint based on Sprint naming pattern XX Spr…

After that, you can use formulas from this report to create a sprint velocity measure: Sprints by sprint name velocity - Issues - eazyBI Demo Training - eazyBI

Kindly,
Gerda // support@eazybi.com