Measure for delivery accuracy

Questions & Answers
1

Hi.
I would like to ask for your help to create an efficient measure for the following:
I want to sum up the Story Point i estimated for a Stories (issueType = Story) that were committed and completed in the sprint.
for example: in sprint planning i planned to do:

  • Story-A: 5 SP
  • Story-B: 10 SP
  • Story-C: 10 SP

And at the sprint closing i delivered:\

  • Story-A: 50 SP
  • Story-B: 100 SP
  • Story-D: 900 SP

I want the measure to return 15 (5+10).
I wrote the following measure but it times out in some reports. would like to explore option to optimize it.

Sum(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
NOT IsEmpty([Measures].[Sprint Story Points completed]

)

),
[Measures].[Sprint Story Points committed]
)

2

Hi!
There is one default Measure that I think it is what you are looking for:
“Sprint Story Points committed completion %”
And if you add a report filter for Issue Type = User Story, bookmarked. Then, you will have what you are looking for.
For instance: (adding the others 2 measures you can check them for testing purposes)

image
image2278Ă—1238 330 KB

3

Hi,
But i am looking for the an absolute value. Not a %.
So how does this measure you mentioned help me get the “15 SP” result i was lookout for?

Sorry if i misunderstood the explanation.

M

4

As I showed you, you have several predefined measures for Sprints.
So, if you want the absolute, you have the “Sprint Story Points completed of committed”.
So, in your case of:
Sprint Planning:
User Story A (5 SP)
User Story B (10 SP)
User Story C (10 SP)
End of Sprint, and you have completed:
A + B + D
It gives you A + B = 15 SP

5

Nacho,
to my understanding, “Sprint Story Points completed of committed”, returns the SP as they were at the time the sprint ended. so in the example above it would return 150 and not 15.
I am looking for an efficient formula that will return 15.

M

6

Hi, as a Scrum Master I´m wondering how it’s even possible to deliver more value as commited.
Story points are “stable” on a backlog item, cause we do not measure spended time.

Jira measures SP based on: SP set in Field “StoryPoints” → At Sprint Start the measure of this task ist “Story Point commited”. When closing this Story at Sprints End, “Story Points completed”
should be the value of “completed from commited”.

I try this on a test environment and give you feedback.

Your Story Lifecycle is:

  1. Team agree on SP: 10 for this Story
  2. The issue is planned to a Sprint, at Sprint Start the value is “10”
  3. After Sprint Start you adjust the SP Value to 50 and close the Story
  4. In Jira Sprint Metrics/eazy BI should be “50” completed from “10” commited.

You want to Measure ONLY THE COMMITED SP at Closing. So 10=10, and the other 40 are just over it?

Correct?

7

@jan-hendrik_woecht, i am trying to develop a more advanced KPI.
So normally if the team committed for 25 SP and delivered 25 SP everybody is happy. But i am expecting the team to deliver the content they committed to, not just the velocity.
So as the team mature i want to “trust” their plan more. I want them to complete “what” they committed to and do that with accurate estimates. Obviously, not achievable 100% in the real life, but would like to have a KPI that starts at 70% and shows improvement over time.

In the example i gave larger numbers at sprint closing to illustrate the result i was looking for. obviously i do not expect team to be so off we estimates.

hope it makes more sense now.
M

1 Like
8

Hi @meravbe,

I’m happy to hear the discussion here!

You may want to try defining a calculated measure with formula below and see if it returns the expected results for you!

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

Best wishes,
Elita from support@eazybi.com

1 Like