How to create filter Today -1 week?

[Vinicius Medina]

Hello,

I have one filter that shows all my closed tickets. Currently 1000+.

Every week I have to check last week's closed tickets and take some information from them to add to another Excel file for a report. I noticed that it's possible to export this filter to Excel, hence I would need just to copy and paste info on this other Excel.

I'm taking my current filter (with all tickets) but struggling to add correct argument to take only tickets from past week.

All my tickets have Schedule Start Time, hence maybe we can have some calculation from this column?

Example: today is 30-Sep (week 40) and on this report I would like to show all ticket from week 39 (22-28 Sep). The information there should change only on week 41.

Is it possible to accomplish this?

[Trudy Claspill · Accepted solution]

Hello @Vinicius Medina 

You can use the startOfWeek function.

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

This can be used as the criteria for any date/time field. For example if you want the issues that were resolved just last week you could use:

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

[Vinicius Medina]

Thanks! I was not sure how those arguments work, since I'm quite new to Jira. Your answer was very helpful.

The current forumla was showing data from 2 weeks ago, but I updated to Resolved <= startOfWeek(1) and Resolved >= startOfWeek(-1) and worked for showing last week's.