Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,558,662
Community Members
 
Community Events
184
Community Groups

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

Edited

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-
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

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
TAGS
AUG Leaders

Atlassian Community Events