Output from one status in a week.

[jeroen_wilmes]

I want to make a filter that measures the output of a status during last week. Without the need to adjust the filter every week.

Can someone help me?

[Bill Sheboy · Accepted solution]

Hi @jeroen_wilmes 

What do you mean by "the output of a status"?  And, what do you mean by "measure"?

For example, if you want to know which issues entered a specific status during the last week, that could use the JQL CHANGED operator and the functions startOfWeek() and endOfWeek()

project = MYPROJECT
 AND status CHANGED TO "In Progress" DURING ( startOfWeek(-1), endOfWeek(-1) )
 ORDER BY Key ASC

To learn more about these functions, please review this documentation:

• https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#CHANGED
• https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#startOfWeek--
• https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#endOfWeek--

Kind regards,
Bill

[jeroen_wilmes]

Thanks @Bill Sheboy  Your suggestion did the trick. 
For others that want to use this, make sure that your workflow is aligned with what you want to measure. If the workflow has transitions, that makes it possible to "skip" a status, then filtering on that status may result in "missing" issues.
I wanted to count the number of issues that came out of a certain status in a week period. The workflow gives only two options: the next status, or cancel.  For me it does work to only count the issues that go into the next status and not the ones that were cancelled.