Project Status last week

Question

Hi,

I used the two dimensional filter Gadget to get an overview of the current Status from all my Projects. Now I want to do a second one with the Status from last week to compare what has changed and what not in each Project.

But I don't know how to Change the JQL to get the result I want. I don't want to see only the changes that happened between the last and the current week. I Need this overview to see what has changed and what not.

my JQL for the current Status is:

project in (xxx) AND issuetype in (Change, Finding, "Simple Change", Aufgabe, "Task with Approval", Unteraufgabe)

Is it possible to just add the time (-7d) to it or do I have to create a new JQL? If so, how?

Thanks :)

Andrijana Volic · Answer

Hi, thanks for you answer.

I found out how it works:

project in (xxx) AND issuetype in (Change, Finding, "Simple Change", Aufgabe, "Task with Approval", Unteraufgabe) AND updated <= startOfDay(-6) ORDER BY status ASC

Alexey Matveev · Answer

Hello,

Maybe it could be like this:

project in (xxx) AND issuetype in (Change, Finding, "Simple Change", Aufgabe, "Task with Approval", Unteraufgabe) and status changed after -7d