Is there a query i can create to see tickets closed by month and add it as dashboard widget

[mohit.gambhir]

Is there a query i can create to see tickets closed by month and add it as dashboard widget

[Valerie Knapp]

Hi @mohit.gambhir , welcome to the Atlassian Community and thanks for your question. 

It's not possible, in the standard configuration of Jira, to have dynamic reports in a dashboard. You could write different JQL filter queries for each month and display a gadget for each of them. 

Otherwise, you would need an app like eazybi or something for dashboards.

I hope this helps you but please write again if you have other questions or doubts. 

Cheers

[mohit.gambhir]

Thanks. What JQL can I create for each month and what gadget can i use

[Valerie Knapp]

Hi @mohit.gambhir , you can use the basic JQL filter query builder like this

and create a filter for each month.

Then, in the dashboard, you need to create a gadget to show each filter. Here I am showing a pie of all of the issues resolved in December 2024 by issue type.

Here is the documentation for how to build a dashboard - https://support.atlassian.com/jira-software-cloud/docs/create-and-edit-dashboards/ 

Here is the documentation on how to use JQL for issue filters - https://support.atlassian.com/jira-software-cloud/docs/what-is-advanced-search-in-jira-cloud/ 

I hope this helps you.

Cheers

[Bill Sheboy]

Hi @mohit.gambhir -- Welcome to the Atlassian Community!

Do you want to see the counts by month or the issues for the month?

You could try the "Created vs. Resolved Chart" dashboard gadget, setting the reporting period to be Monthly.  This will show the counts, month-by-month.  To see the specific issues, select a month on the chart and then open them with "View in issue navigator".

Kind regards,
Bill

[Danut M _StonikByte_]

Hi @mohit.gambhir,

Welcome to the Atlassian community!

Do you want to list those issues grouped by month, to display a stat in form of number of closed issue per month, or a trend chart based on the past months?

Jira offers some gadgets like Filter Results gadget - to display the issues from a filter that return closed issue from certain month(s), Created vs Resolved gadget - shows how many issues were created past months and how many of them were resolved.

But for better stats you could search for a plugin on Atlassian Marketplace that offers such gadgets.

if you consider the option of using a plugin, our Great Gadgets app offers gadgets that lets you display closed issues in past month in any way you want - all the cases that I mentioned before. Here are some gadgets of our app that will solve this:

Kanban Velocity gadget - can display the closed issue per month as a chart and calculate current velocity (closing ration). On its Data tab can list the issue closed every month. 

Pivot Table & Pivot Chart - can display multidimensional tables, charts just like pivot tables in Excel. You can use it to display closed issue per month as table, heat-map tables or charts.

If you need any help in configuring these gadgets, feel free to contact us at support@stonikbyte.com.

Danut.