We are trying to breakdown some data on a weekly aggregate level, wherein a week is counted as Sunday - Saturday.
However, the weekly aggregate provided by Report Builder is only Monday - Sunday...
How do we change this?
We've noticed there's a way to do a Rolling Weekly, and you can specify a day of a certain week you wish it to start on, as well as a day of a certain week you want it to end on... however this has not worked.
We also noticed there's also another way to customize using the format 'cw-2w+6d' - 'cw+5d'.... however this also has not worked.
Any help or advice on how we can get the Sunday - Saturday weekly aggregate, would be much appreciated.
Please note customizing the calendar will not only change the week definition for report builder but for other Analytics tools as well & the change will only apply to the data that is received after you make this change to the report suite but there will be no impact on the historical data.