1.5K members online now
1.5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

How can I set Week() function to return Monday-Sunday week numbers and not Sunday-Saturday ?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hello,

 

Some of the accounts we manage are set up to work with weeks starting on Sunday (and not Monday).

Is there way to create a week_number dimension that will present the week number in this format (Sunday - Saturday)?

 

 

Thanks,

1 Expert replyverified_user

How can I set Week() function to return Monday-Sunday week numbers and not Sunday-Saturday ?

Rising Star
# 2
Rising Star

Hi Roy,

 

Yes there is.  You can always define your own data set and import it.  If you are using GA as our data source, you have the choice of week (Sunday - Saturday) or ISO week which is Monday - Sunday.

 

Hope that helps.

 

Cheers,

 

Theo Bennett

Analytics Evangelist at MoreVisibility | Contact Me
Connect on LinkedIn