Story Points removed from Active Sprint to other Sprint

Questions & Answers
1

Hello all, I hope you all doing fine.
I’m trying to calculate all issues removed from the sprint.
Pls let me explain my sprint structure/logic at once.
In my case I have other sprints too in my project as not active ones (Future sprints).
We are using them to grouping issues. And some of these future sprints having start and end date and some of not.

Condition : So, during the sprint, issues can be move from the active sprint to Backlog or other sprints in which these other sprints.

The formula I have :
( [Measures].[Story Points removed],
[Transition Field].[Sprint status],
[Sprint Status].[Active],
– An issue was removed from an active sprint
[Issue Sprint Status Change].[Active => (none)]
)

I had tried to add [Issue Sprint Status Change].[Active => Future ] ( I dont know if it’s possible) however there is no value in my formula.

What should I do? Could you please help me?

Also I will need to update my Story Points added report too with same approach.
( [Measures].[Story Points added],
[Transition Field].[Sprint status],
[Sprint Status].[Active],
– An issue was added or created in an active sprint
[Issue Sprint Status Change].[(none) => Active]
)

Thanks in advance.
Nihal

2

Hi @NhlcpN,

Unfortunately, there is no straight transition from Active to Future in the Issue Sprint Status Change dimension. That is why your calculated measure is empty. As a workaround, you can define a new calculated measure that would iterate through issues and retrieve ones that were removed from the current Sprint and were added to any future Sprint at the same time. The formula could look similar to the one below:

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Issue].CurrentHierarchyMember.GetString('Sprint ID') <>
    [Sprint].CurrentHierarchyMember.GetString('URL_ID')
  ),
  CASE WHEN
    -- issue removed from current sprint
    ([Measures].[Transition from last timestamp],
    [Issue Sprint Status Change].[Active => (none)])
    =
    -- at the same time it was moved to any future sprint
    ([Measures].[Transition from last timestamp],
    [Issue Sprint Status Change].[(none) => Future],
    [Sprint].CurrentHierarchy.DefaultMember)
  THEN
    [Measures].[Sprint issues removed]
  END
)

Best,
Roberts // support@eazybi.com

3

Hello Roberts, I impemented and worked great, thank you so much. Have an amazing day :slight_smile:

1 Like