In Report Builder, how do I change the date granularity for weeks to start on a Sunday instead of the default Monday? | Community
Skip to main content
B
bchoi17
August 21, 2020
Solved

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

  • August 21, 2020
  • 3 replies
  • 1760 views

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by saumyag24417044

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

 

 

3 replies

Brian_Johnson_
Brian_Johnson_
Level 8
August 21, 2020

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

S
saumyag24417044Accepted solution
Level 4
August 24, 2020

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

 

 

K
kainth
Level 6
August 24, 2020

Hi @bchoi17,

Adding to what @saumyag24417044  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/customized-date-expressions/t-customized-date-expressions.html

 

Hope this helps.

 

Regards,

Abhinav

Terms & ConditionsAccessibility statement

Loading footer...