Calculating current story points for added issues in sprint

Questions & Answers
1

Hi easyBI community,

I am looking to measure the story points for issues added after the sprint starts.
It is important that the story points reflect the current state of the issue (or the Story points when the sprint closed), but not the ones when the story was created.

I can’t use the Sprint Story Points added measure, because our users sometimes create issues by duplicating others, and then change the story points.
This gives me wrong measures.

Thank you

2

Hello @zvika,

Thanks for posting your question!

Based on your description, I suggest using the “Story points history” measure in your report.
You can read more about the Story point measures in our documentation here: Jira Software custom fields

Additionally, consider using the Time dimension to capture the story points that were added after the sprint began. The “Story points history” measure will show the story points an issue had at the end of the selected time period. To get accurate results, you can filter by a specific day, week, or month to match your reporting needs.

Let me know if you get the expected result.

Best,
Marita // support@eazybi.com

3

Thank you @Marita_Norvele for your response,

I am trying to do this calculation per sprint, using the Sprint or Sprint ID (custom field) as the Row.
The “Story points history” shows me the number of story points at a specific time, but I can’t tell which issues were added after the sprint started or how to aggregate them per sprint.

How do you suggest I do this?

4

Hi @zvika,

I suggest the following calculated measure:

Sum(
  Filter(
    Descendants([Issue].CurrentMember,[Issue].[Issue]),
    [Measures].[Sprint issues added] >0
  ),
  [Measures].[Story Points history]
)

First, this formula looks at all issues in your selection (using Descendants)
Then it filters to keep only issues that were ever added to any sprint (where [Sprint issues added] > 0)
Finally, it sums up the Story Points for these filtered issues at the end of the selected time period (using Story Points history)

This formula would be useful for analyzing the total Story Points of issues that have been part of sprints, showing their current/historical Story Point values rather than just the initial values.

Best,
Marita // support@eazybi.com