Is there a way to exclude cancelled work items from the velocity report?

[Rebecca Hylek]

Our teams would like to have the velocity report exclude work items that were cancelled as it impacts their metrics.  We've recommended that they first remove it from the sprint but they often forget or would prefer to not remove an item that they committed too.  Our next suggestion was to reduce the points to zero.

Curious if there's a way to simply exclude them altogether from the velocity report without remembering to do one of the above options.

Thank you!

[Trudy Claspill]

Hello @Rebecca Hylek 

Is this for a Team-managed project or a Company-managed project, or a Scrum board based on a filter?

It isn't possible to change the Velocity report itself. You would need to change the board configuration.

If it is Company-managed or based on a filter you can change the board filter to exclude the cancelled work items. As soon as they are set to cancelled they will no longer appear in the board and won't be counted in the Committed or Completed values of the Velocity report.

If you're using a Team Managed project you can't modify the board filter. I think the only way to accomplish your requirement is if Cancelled is a status and you move that status to the Unmapped Statuses column in your board's column configuration. I haven't had a chance to test that yet.