Averaging Sprint Points

[Jon Collins1]

Hello everyone!

I am hoping someone can help me figure the best way to build a report that averages sprint points across multiple iterative sprints. 

Essentially, I'd like to be able to run a report and see what sprint team "X" is averaging for points per sprint over a specific time period (e.g. 3 months, 6 months, etc...).

I'll admit my reporting skills in ServiceNow are not the best. Can anyone point me in the right direction to begin this? 

Thanks!

Jon

[Uncle Rob · Accepted solution]

If you want to track performance over time, you're going to need Performance Analytics.  You'll need the premium version if you want to build analytics against stories.  This one seems simple enough.

- build an indicator source that selects stories with >0 points.
- build an indicator that calculates the average of the story points
- put a breakdown of assignment group (and any other element you might want to break down avg story points by)
- add that indicator to a timeline widget.

If you don't have Performance Analytics, I don't know any other way to accomplish it other than running a report that averages the points over a manually selected range and constantly logging that elsewhere (excel).

If you do have PA, but don't know how to build this, we can help.

[Jon Collins1]

Thanks Robert!

[Uncle Rob]