Hi, I am looking to extract issue committed and completed data at assigned user level

[mohd_zakir]

Hi, I want to extract each project's number of issues committed , completed , added or removed in a sprint for performance analysis.

[Alexey Pavlenko _App Developer_]

Hi @mohd_zakir ,

In which form you would like to extract it? Natively, at the assignee level, unfortunately, it's impossible to do. Since it's not recommended to track velocity or metrics individually in agile. If you needed to do the same not at the assignee level and in the form of view and one by one - you could use the Sprint Report and Velocity Report.

If you still would like to display the info at the assignee level, you can use the app I developed - Multi-team Scrum Metrics & Retrospective. For that you would need to use the custom JQL feature.

Example, for the Completed scope:

Also, you can display several sprints and several teams/boards in a single view and be able to have JQL of it (button View in Issue Navigator), or even aggregate sprints into years/half-years/quarters/months 

With it you can also conduct in-place retrospectives and drill-down into periods below - years -> half-years -> quarters -> months -> sprints.

Or you can view summary in this way:

You can view the result of retrospectives this way afterwards for further analysis:

There are much more features inside.

Best regards,
Alexey

[Viktoriia Golovtseva _TitanApps_]

Jira provides various ways to track sprint performance, including burndown charts, velocity reports, and sprint reports, but extracting specific metrics like the number of issues committed, completed, added, or removed across multiple projects can require additional tools or custom reporting.

Here are a few ways you can gather and analyze these sprint performance metrics:

1. Sprint Reports & Velocity Charts

Jira's Sprint Report helps track committed vs. completed issues, while the Velocity Chart shows the average amount of work completed per sprint. However, these reports are limited to individual boards, making cross-project analysis challenging.

2. JQL Queries for Issue Tracking

Using JQL (Jira Query Language), you can retrieve issues based on sprint history:

• Committed Issues: sprint in openSprints() AND status was not Done before startOfSprint()
• Completed Issues: sprint in closedSprints() AND status = Done
• Added Issues: sprint in openSprints() AND created >= startOfSprint()
• Removed Issues: sprint in closedSprints() AND NOT sprint in openSprints()
  While useful, JQL does not aggregate these metrics across multiple sprints or projects without manual effort.

3. Smart Productivity & Team Performance Dashboard for Jira

If you need a centralized view of sprint performance across multiple projects, the Smart Productivity Dashboard provides:

• Aggregated sprint statistics: Track how many issues were committed, completed, added, or removed per sprint.
• Comparison across teams and projects: See performance trends across multiple sprints and teams.
• Real-time insights: View sprint progress alongside issue tracking data from Jira, Confluence, and GitHub.
• Team-based analysis: Organize users into teams (e.g., Developers, QAs, Designers) to compare sprint efficiency.

This allows teams to quickly assess sprint performance, identify trends, and make data-driven decisions without manually extracting issue counts.

[Rahul_RVS]

Hi @mohd_zakir 

Welcome to the community !!

If you would be interested in a mktplace app for this requirement, pls do take a look at 
Agile Velocity & Status Gadgets 

The app comes with few dashboard gadgets to track team member's / team's velocity / productivity based on story points / time spent / issue count in a sprint  and also track sprint status with multiple parameters. The app works for past / closed sprints too.

Disclaimer : I am part of the team which developed this app

[Valeriia_Havrylenko_SaaSJet]

Hi @mohd_zakir   👋
Welcome to the Atlassian community!

If an app is an option for you, try Time In Status. Issue committed and completed data are available through Sprint Performance Report feature.

Add-on developed by my team.

Have a nice day and happy sprinting 🥳