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

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL filter help Edited

Hello,

I need some help with the following requirements.

• Started Sunday @ 12am with = for example 200 tickets
• Received 140 new tickets throughout the week
• Closed 75 tickets throughout the week
• Left with 265 tickets as of 11:59 pm on Saturday

And will be cycled through all the weeks.

Thank you.

 

1 answer

0 votes
Jack Community Leader Jan 28, 2020

I don’t understand your question here. It seems more like a statement of facts describing a recent week’s activities. 

Hi Jack,

Thanks for your response, let me give you more information, I am looking for a filter which shows last week remaining(not closed) tickets, for example, let's assume I have 200 tickets on Monday(Starting 12 AM) and I have received 140 tickets throughout the week and I have closed 75 tickets in that week, by the end of the week(Sunday 11:59 PM  ) I will be left out with some tickets. I need a filter based on the above example to show the remaining tickets.

Thank you,

Murugan.

Jack Community Leader Jan 28, 2020

Something like this maybe?

createdDate >= startOfWeek() and resolution is empty

you can set up a subscription and run it at the end of the week. Note this assumes your are setting the resolution when moving issues to Done.

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you