Hi All,
I want to create a 6 weeks avg report which shows day wise data. For eg: I want to show previous 6 weeks Monday data in one worksheet and previous 6 weeks avg Tuesday data in another worksheet.
I used rolling data and used custom date range as well, but as the weekly rolling data shows for 7 days once, the second week's data changes its day.
Eg: I am displaying data from 11th April 2022. Technically I want the next week Monday date to be 18th April. But due to the weekly rolling dates, I am getting 17th April in the Monday worksheet. But 17th is Sunday. I am attaching the trend from Report Builder for your reference

Could Someone please advise?
Regards,
Shilpa