On every Monday, I need to submit the weekly report of the type of issues, and the number of issues, and their current status of the last 1 week. I would also need that data to be presented on a dashboard automatically every Monday along with previous weeks' data. (Eg: If we are in Week 31 as of now, I need the data of the last 8 weeks data).
I tried the below filter for the last 1 week data
createdDate >= startOfWeek(-1) AND createdDate <= endOfWeek(-1)
How to get the same data for all the weeks periodically?