Create Report: Total Committed Story Points vs Completed Story Points

[Shawn8]

Good morning, I'm having some issues creating a report in ServiceNow on total committed story points vs completed. I'd like to do a "double spline" type graph with committed overlaid with completed. 

I'm in the rm_story table and when I try to group by sprint I'm basically getting incorrect data stacked in one spot with months (for some reason) shown across the bottom.

I'd like to have each sprint along the x-axis and committed points along the y axis. This is probably such a basic question but I can't get the report to work. 

Thanks in advance for any help and suggestions!

[Shawn8]

Thanks, using the story table gets me closer to the representation I want. I'm able to see points in the sprint and points completed in each sprint. 

My only issue now seems to be the ordering of the dataset. The bar chart seems to randomly pick an order for the sprints and it's not seemingly based off of the short description or the calendar month (so they are all out of order March, December, February, October, and so on)

Thanks again, I really appreciate your assistance. 

[NikEng1]

Glad to hear I could help!

Regarding the sorting, you can sort the columns, but only by the same value as you have grouped the values by. use the "add sort" button above the filter. The grouping should be the same for all data sets, but I think it's enough to set the sorting in the main report.

In this example, I have grouped and sorted by sprint.number, a to z:

If you group by "sprint" (ie not the number) the default behavior seems to be to show the short description on the X axis, which can also be sorted alphabetically. Unfortunately in order to sort by time, like planned_end_date, you have to group by this value as well instead of by sprint. But the sprint number might correspond with time in some sense at least.