I'm trying to change the date granularity for weeks to start on a Sunday (thru Saturday) instead of the default Monday (thru Sunday) in Report Builder? Is this possible? Thank you!
Hi @bchoi17,Adding to what @saumgupt said, I think the better option will be to use "Date from Cell" or use "Rolling Dates" & use the customized expressions as shown below.
1. Date from Cells:
2. Rolling Dates:
For more information on using expressions in Report Builder, you can refer to the below documentation link.
Hope this helps.
In order to change the week to start on a Sunday, you need to use "Customize Calendar" option in Analytics UI as follows:
Admin > Report Suites > Select report suite > Edit Settings > General > Customize Calendar
There you can modify the First Day of Week - screenshot below:
Document Reference: https://docs.adobe.com/content/help/en/analytics/admin/admin-tools/custom-calendar.html
This is possible, but it is a change that impacts the data processing and any/all reporting options (Workspace, Report Builder, Data Warehouse, etc) for the report suite. Details can be found here: https://docs.adobe.com/content/help/en/analytics/admin/admin-tools/custom-calendar.html