In Report Builder, how do I change the date granularity for weeks to start on a Sunday instead of the default Monday?

[bchoi17]

Hello, 

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!

[Brian_Johnson_]

Hi, @bchoi17 

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

[Saumya-In · Accepted solution]

Hi,

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

Thanks,

Saumya

[kainth]

Hi @bchoi17,

Adding to what @Saumya-In  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.

Link: https://docs.adobe.com/content/help/en/analytics/analyze/report-builder/data-requests/date-ranges/cu...

Hope this helps.

Regards,

Abhinav