JQL for displaying the issues 'done' in a particular year breakdown by month

[Vasu Dev]

Hello friends!

Could you please assist me with the JQL query to retrieve the number of stories completed in a specific year, broken down by month? I have constructed the following query:

Project = ABC and status = "Done" AND Resolved >= '2024-01-01' and Resoved <= '2024-12-31'

The query retrieves the data, BUT it doesn't display it by month-wise. I used a two-dimensional filter statistics gadget to display data.

I need the report in the following example format:

---------------------

Month     Count

---------------------

Jan              15

FEB              20

Any help is apperciated!

Thanks in advance!

[Rilwan Ahmed]

Hi @Vasu Dev ,

Welcome to the community !!

You cannot do this directly in Jira. You need to export the tickets with Resolved date to CSV and then make use of Data --> Filter in MS Excel for Resolved date column Or make use of Pivot table.