Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Getting Cumulative Story Points Resolved

I'm trying to write a report in EazyBI to get the cumulative story points resolved across sprints. So if I had the following sprints:

S1: 13 points
S2: 19 points
S3: 17 points

What I want is for the calculation to return:

S1: 13 points
S2: 32 points
S3: 49 points

Given this is an actual example from the documentation, I was surprised that it didn't work. My Calculated member looks like:

Sum(
  { PreviousPeriods([Time].CurrentHierarchyMember),
   [Time].CurrentHierarchyMember },
  [Measures].[Story Points resolved]
)

I have that set as the selected measure in rows, and the columns being sprints (I tried it the other way, too). What I see is each sprint listed with the total points resolved that sprint, but not cumulatively (so 13,19,17 instead of 13,32,49) . What am I missing here?

2 answers

1 accepted

0 votes
Answer accepted

Well, if I want Cumulative Sprints, then I should actually do that!

Sum(
  { PreviousPeriods([Sprint].CurrentHierarchyMember),
   [Sprint].CurrentHierarchyMember },
  [Measures].[Story Points resolved]
)

Note the change from Time.CurrentHierarchyMember to Sprint. That solved the issue for me.

Hi Cory,

It seems you already found an answer, but anyway you could also try defining a new user-defined calculated member in "Measures" dimension using this code example:

 

 

Sum(
  Head(
    ChildrenSet([Sprint].[Sprints]),
    Rank([Sprint].CurrentMember,
      ChildrenSet([Sprint].[Sprints])
    )
  ),
  [Measures].[Story Points resolved]
)

 

Please contact support@eazybi.com if you have further questions regarding this!

 

Kind regards,

Martins Vanags / support@eazybi.com

where to write this code?

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Marketplace Apps & Integrations

Happy New Year and Welcome New Marketplace Partner Program Partners!

Happy New Year! We hope you all had a safe and restful holiday season. 2020 was a unique year full of unforeseen events; however, as we enter the new year of 2021, we’re optimistic for the light at t...

509 views 7 18
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you