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

Avatar

Avatar
Level 1
bchoi17
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
bchoi17
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
bchoi17
Level 1

21-08-2020

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!

Accepted Solutions (0)

Answers (3)

Answers (3)

Avatar

Avatar
Affirm 25
Level 4
kainth
Level 4

Likes

49 likes

Total Posts

117 posts

Correct reply

26 solutions
Top badges earned
Affirm 25
Give Back
Boost 5
Boost 3
Boost 25
View profile

Avatar
Affirm 25
Level 4
kainth
Level 4

Likes

49 likes

Total Posts

117 posts

Correct reply

26 solutions
Top badges earned
Affirm 25
Give Back
Boost 5
Boost 3
Boost 25
View profile
kainth
Level 4

24-08-2020

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

Avatar

Avatar
Shape 1
Level 2
Saumya-In
Level 2

Likes

9 likes

Total Posts

44 posts

Correct reply

6 solutions
Top badges earned
Shape 1
Boost 5
Boost 3
Boost 1
Affirm 5
View profile

Avatar
Shape 1
Level 2
Saumya-In
Level 2

Likes

9 likes

Total Posts

44 posts

Correct reply

6 solutions
Top badges earned
Shape 1
Boost 5
Boost 3
Boost 1
Affirm 5
View profile
Saumya-In
Level 2

23-08-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:

 

image.png

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

 

Thanks,

Saumya

 

 

Avatar

Avatar
Affirm 50
MVP
evolytics_brian
MVP

Likes

80 likes

Total Posts

170 posts

Correct reply

54 solutions
Top badges earned
Affirm 50
Applaud 25
Establish
Seeker
Give Back
View profile

Avatar
Affirm 50
MVP
evolytics_brian
MVP

Likes

80 likes

Total Posts

170 posts

Correct reply

54 solutions
Top badges earned
Affirm 50
Applaud 25
Establish
Seeker
Give Back
View profile
evolytics_brian
MVP

21-08-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