How to write JQL if i want to see the tickets per week upto present week for last 24 months?

Question

Hi there, I tried- status in (Resolve, Resolved) AND resolved >= startOfMonth(-24) this only displays resolved tickets for last 24 months but i want the tickets to display week wise for last 24 months. How can this be possible using JQL? Please suggest

Rik de Valk · Answer

Hello @S S , using only a Jira filter you cannot group issues. 
You will need to use a Filter in combination with a Dashboard gadget.

The filter you described can be used as the Filter.

Now you create a new Dashboard and add a gadget to display the issues in a grouped manner. One gadget that comes to my mind is the Time Since gadget where you choose the options:

* Date field = Resolved
* Period = Weekly
* Days previously = 720
* Cumulative totals = No
* Refresh interval = Never (unless you want to use it as a wall board)

Nic Brough -Adaptavist- · Answer

Welcome to the Atlassian Community!

What do you mean by "week wise"?

My guess is that is about the display of the issues.  JQL does not have anything to say about how you display the results of a search.  You will need to use your search in a display function that supports grouping by week.  The issue navigator (the grid-like view you get when you just search for issues) does not have a function for grouping into weeks.