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

Vasu Dev January 12, 2025

 

 

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!

 

 

5 answers

0 votes
Vasu Dev January 14, 2025

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!

0 votes
Danut M _StonikByte_
Atlassian Partner
January 13, 2025

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.

image.png

image.pngTo 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. 

image.png

Danut

0 votes
Aron Gombas _Midori_
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 13, 2025

Hey, @Vasu Dev

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

jira-excel-export-created-vs-resolved-pivot-table.png

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!

jira-data-center-excel-automation-send-xls-result.png

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

0 votes
Thorsten Letschert _Decadis AG_
Atlassian Partner
January 12, 2025

Hi @Vasu Dev ,

This might not be doable with out-of-the-box features.

The "Created vs. Resolved Chart" gadget for dashboards probably comes closest, but it has some flaws. For example, as the name suggests, "created" issues are also displayed, and the period cannot be specified statically either since it's controlled via a “days previously” field.

If using an additional app is an option, you might want to look at sumUp for Jira. It ships already-known gadgets like the Two-dimensional one with smart extensions like grouping by date-time fields. If you run into any questions, please let me know.

P.S. I'm part of the team behind the aforementioned app.

Regards,
Thorsten

0 votes
Rilwan Ahmed
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
January 12, 2025

Hi @Vasu Dev ,

Welcome to the community !!

You cannot do this directly in Jira. You need to export the Issue Key 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 as explained in  https://www.statology.org/excel-group-by-month/

Sample report:

image.png

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events