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

S S May 18, 2022

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

2 answers

0 votes
Rik de Valk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
May 18, 2022

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)
0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 18, 2022

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.

Suggest an answer

Log in or Sign up to answer