Is there a query element wherein I can query specific tickets using months?

[Sherwin Soriano]

My manager would like to have a dashboard wherein, it will show how many tickets we close on a monthly basis.

I am not sure if there is a dynamic query that can be used to this.

[Izabela França · Accepted solution]

Hello, @Sherwin Soriano !

You can use the function startOfMonth() combined with the status to return items resolved in the current month.

Example:

status = Done AND resolved >= startOfMonth() ORDER BY resolved DESC

Here is the official documentation about this function [LINK HERE]

Hope it helps :)

[Sherwin Soriano]

Thank you!

Is this query on a monthly basis? I did not know that ">=startofMonth()" is that parameter! :)

[Izabela França]

It always shows the current month, so if you check the search today it will show the work items resolved in May. But if you check it in July, it will automatically show the items resolved in July. You do not have to adjust the JQL for the next months.

[Danut M _StonikByte_]

Hi @Sherwin Soriano ,

Jira offers some JQL functions that would allow you to filter the issues by their resolution date:

resolved >= startOfMonth() - returns the issues resolved in the current month

resolved >= startOfMonth(-1) AND resolved <= startOfMonth() - returns the issues resolved last month

resolved >= startOfMonth(-2) AND resolved <= startOfMonth(-1) - returns the issues resolved 2 months ago.

But if you want this info to be displayed on a dashboard, it will be more convenient to use a gadget. you could try using Jira's Filter results gadget configured with a filter like this to list the issues.

You could also try Jira's Created vs. Resolved gadget, but as far as I know, it shows the issues created each month and how many of them were resolved. So it might not be what exactly you want.

For more accurate data and ease of use, my advice is to look for a plugin on the Atlassian Marketplace.

In case you consider the idea of using a plugin, our Great Gadgets app offers a Kanban Velocity / Throughput gadget that can display the number of issues closed per month along with the rolling average (velocity).

On its optional Data tab, it can display the issues resolved each month:

The same app offers a Pivot Table & Pivot Chart gadget that allows you to display the count of issue resolved by month and split by project, assignee or other fields. The result can be in form of a table, heat-map table or chart of various types. 

Hope this helps.

Danut

[Jonathan Tang]

You might consider the Dashboard tool, then the widget "Created vs Resolved" graph.  All you need to do is pre-create a filter based on the project or criteria you want.

No need to set a rolling date filter.  The widget will do it for you.  Just configure it for monthly. 

The business value here is it also trends the tickets created. So if the team is slowly falling behind, you can argue the need for more resources - either proactively with better code delivery, or reactively, with more support staff to fix the problems.