Simple burnup chart

Questions & Answers
1

Hello, I’m trying to put together a burnup chart for an epic, and for some reason it does not work. I went through a lot of iterations, but here is my current issue:

Sum(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
CASE WHEN
   DateInPeriod([Measures].[Transition to status first date],[Time].CurrentHierarchyMember) AND
   [Measures].[Transitions to status] = 1
THEN
  [Measures].[Story Points]
ELSE
 0
END)

Where the issue is that if a story loops through the “in progress” → “documentation” → “done” state twice (due to some concens, this is what happened), it will count it twice, first in the initial week it happened, then in the next week when it happened. I put there the [Measures].[Transitions to status] = 1, but it does nothing. one extra trick I have to achieve: the union of the done and documentation should be counted to the sum, so whichever state the issue reaches first.

2

Hi,

We can adjust the formula to show up the story points only for the very first period when the transition happened:

Sum(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
CASE WHEN
  ([Measures].[Transition to status first date]=
([Measures].[Transition to status first date],[Time].CurrentHierarchy.DefaultMember)
THEN
  [Measures].[Story Points]
ELSE
 0
END)

Kindly,
Janis, eazyBI support