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!
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!
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.