Extracting Data from Jira

This process generates a column of numbers representing your team's throughput per day. We will use the "Resolved" date from Jira and aggregate it by day in Excel, ensuring days with no completed work are included as "0".

2 0 3 1 ...

Log in to your Jira instance, click Filters > Advanced Issue Search, then switch to JQL mode.

Paste the JQL Query:

Adjust the `project`, `type`, and `status` fields as needed for your team.

project = "YOUR_PROJECT_KEY" AND type in (Story, Bug) AND status = Done AND resolved >= -365d

The `-365d` limits data to the last 365 days. Choose whatever time period is relevant for your team.

Crucial Step (Column Options):

1. Click Columns in the top right.
2. Ensure the Resolved field is checked and visible.
3. Click Export > Export Excel CSV (Current fields).

Warning: Do NOT select "All fields" or your file will be massive and hard to work with.

Create the PivotTable:

1. Open the CSV file.
2. Select your data, go to Insert > PivotTable, and click OK.
3. Drag Resolved to the Rows area.
4. Drag Issue key to the Values area (ensure it's "Count of Issue key").

Group the Dates:

1. Right-click on any date in the "Row Labels" and select Group....
2. In the pop-up, select only Days and click OK.

CRITICAL: Force Zeros for Empty Cells

1. Right-click inside the PivotTable and choose PivotTable Options....
2. In the Layout & Format tab, check For empty cells show: and type 0 in the box.
3. Click OK.

1. Highlight the numbers in the "Count of Issue key" column (do not include the Grand Total).
2. Copy the data (Ctrl+C or Cmd+C).
3. Open a new, blank sheet and click cell A1.
4. Paste the data.

This gives you a clean, vertical column of daily throughput numbers ready for analysis.