Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to create retrieve report based in sprints

Lisa New December 2, 2024

How to pull report based on sprints in jira

1 answer

0 votes
Renata_Getint
Atlassian Partner
December 2, 2024

Hi @Lisa New

To pull a report based on sprints in Jira, you can use one of these methods:

1. Use Built-in Jira Reports

Jira offers several reports tailored to sprint-based data. Here's how you can access them:

  1. Go to your Jira Project.
  2. Click on Reports from the left-hand menu.
  3. Select a report such as:
    • Sprint Report: Shows the issues completed during a sprint and any issues not completed.
    • Velocity Chart: Displays how much work was delivered in past sprints.
    • Burndown Chart: Tracks work progress within the sprint.
  4. Select the sprint you want to analyze from the dropdown menu.

2. Use JQL (Jira Query Language)

You can use JQL to filter issues by a specific sprint:

  1. Go to the Filters menu and click Advanced Issue Search.
  2. Use a query like:
    makefile
    sprint = "Sprint Name"
    Replace "Sprint Name" with your actual sprint name or ID.
  3. Modify the query to include additional filters, such as:
    java
    sprint = "Sprint Name" AND status = "Done"
  4. Save or export the results if needed.

3. Create a Custom Dashboard

  1. Go to Dashboards and create a new one or edit an existing dashboard.
  2. Add gadgets like:
    • Issue Statistics: Filter issues by sprint.
    • Two-Dimensional Filter Statistics: Compare sprint data across other fields like assignee or status.
    • Sprint Burndown Gadget: Visualize sprint progress.

4. Use Third-Party Apps

If you need advanced reporting, consider apps like:

  • eazyBI Reports and Charts: For customizable reports and charts based on sprint data.
  • Jira Align: For portfolio-level sprint analysis.
  • Advanced Roadmaps: For sprint planning and reporting.

5. Export Data for External Analysis

  1. Use the Advanced Issue Search with your JQL query.
  2. Export the results to Excel or CSV for further manipulation.

Let me know if you need help with a specific report or query setup! 😊

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events