Expand my Community achievements bar.

SOLVED

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

Avatar

Level 1

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!

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Level 4

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:

 

image.png

Document Reference: https://docs.adobe.com/content/help/en/analytics/admin/admin-tools/custom-calendar.html

 

Thanks,

Saumya

 

 

View solution in original post

3 Replies

Avatar

Level 8

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

Avatar

Correct answer by
Level 4

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:

 

image.png

Document Reference: https://docs.adobe.com/content/help/en/analytics/admin/admin-tools/custom-calendar.html

 

Thanks,

Saumya

 

 

Avatar

Level 6

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:

kainth_0-1598279647199.png

 

2. Rolling Dates:

kainth_1-1598279692299.png

 

 

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