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

[Johnathan]

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

[Trudy Claspill · Accepted solution]

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

[Johnathan]

Marvelous!

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

J