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

Is it possible to get the date range from a week as a calculated field?

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I need to create a dimension that shows the week range of my data in my Google Adwords, something like:

 

Week                       Impressions

 

Feb-26 to Mar-4       1000

Mar-5 to Mar-11        10000000

 

Doing this using a spreadsheet would be relatively simple, but I´ve tried doing this direct on Google DataStudio by creating a new calculated field, but apparently can´t add or subtract days from dates.

 

Is there a way I can get this dimension?

 

 

Thank you! 

Is it possible to get the date range from a week as a calculated field?

Participant ✭ ✭ ☆
# 2
Participant ✭ ✭ ☆

I don't know of any way to do this, but I wonder if you can create a dimension called "week starting date"?