Track sprint story points by assignee in Jira Cloud

Platform Notice: Cloud Only - This article only applies to Atlassian products on the cloud platform.

Summary

Discover how to filter and export details to view story points per assignee in a Sprint.

Solution

Filtering the sprint and exporting results

  1. Search for the required work items using JQL.

    Sample JQL: project = <project Key> and Sprint = <Sprint Name or ID> ORDER BY assignee ASC
  2. Include both Assignee and Story Points as columns in your search.

  3. Export the results in an Excel or CSV file and filter them by assignee to get the total story points assigned to each user.

The above JQL will give the results for the specified JQL. To fetch the details for all open sprints, use Sprint In openSprints() in the JQL expression.

Related links

Updated on June 13, 2025

Still need help?

The Atlassian Community is here for you.