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

Question

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!

Vasu Dev_lrtvl3 · Answer

Hello!

Thank you so much for your suggestions! I really appreciate your time and insights. I’ll definitely look into the suggestions you’ve provided and will keep you updated on the progress. Thanks again for your help!

Danut M _StonikByte_ · Answer

Hi @Vasu Dev,

Welcome to the Atlassian Community!

I'm afraid that Confluence cannot display the data in that format. Most likely, you will need a plugin.

If you are willing to install a plugin, our Great Gadgets app (for Confluence) offers some macros that can display this info with just a few clicks.

By using the Pivot Table & Pivot Chart macro you can display the issue split by months in form of a table or chart.

To achieve this, the macro should be configured with a filter like yours, the statistic should be by Resolved field formatted to display the month.

Also, the same app offers a Kanban Velocity macro that can display a chart with the issues resolved each month.

Danut

Aron Gombas _Midori_ · Answer

Hey, @Vasu Dev!

The Better Excel Exporter app has a report template that creates exactly what you want:

If you don't need the "Created" column, just remove that from the template. If you need another column, just add that to the template. The pivot table is super-easy to customize.

💡 Pro tip: if you want to receive this (or any other) report monthly, you can automatically export and email the Excel report using the free Better Excel Automation app!

(Discl. these apps are developed and supported by our team.)