What is the JQL to show tasks that were revolved: a week to date + show tasks completed last week

Johnathan May 6, 2024

Hi All,

I have a client looking for a dashboard that shows:

  • All tasks completed (so far) this week
  • All tasks completed last week

The JQLs need to be displayed in two seperate gadgets, and change accordingly with the date.

 

Thanks ahead for anyone that can help with the JQL!

Best,

Johnathan

2 answers

1 accepted

2 votes
Answer accepted
Trudy Claspill
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 6, 2024

Hello @Johnathan 

What is the definition of "completed"? Are they basing that on when the Resolution was set, or on when an issue was changed to a specific Status?

If the former then the JQL for "completed this week" would be

Resolved >= startOfWeek()

Refer to: https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#startOfWeek--

For tasks completed last week the JQL would be

Resolved >= startOfWeek("-1") and Resolved <= startOfWeek()

0 votes
Johnathan May 6, 2024

Marvelous!

Thanks so much @Trudy Claspill , that was very helpful :)

J

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events