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?