AdWords is now Google Ads. Our new name reflects the full range of advertising options we offer across Search, Display, YouTube, and more. Learn more

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

Date range comparison

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I am unable to see the Default Date Range options under the Data tab for Report, Page or individual items.  I had them at one point but no longer have the option to do a comparative analysis based on a date range.  See Screen Shot Below.

 

Thanks in advance.

 

Screen_Shot.png

 

 

 

Date range comparison

[ Edited ]
Visitor ✭ ✭ ✭
# 2
Visitor ✭ ✭ ✭

I now suspect it to be because I don't have a YYYYMMDD field, I only have YYYY for Fiscal and YYYY for Calendar, MM as well as a QTR field. I tried creating a concat field; CONCAT(CalYear,Month) and formatted as YYYYMM but still no luck.

 

 

CONFIRMED:  I did another concat field with the YYYYMM field and added; CONCAT(YYYMM,1)

This now offers the default date range.  

 

I guess my question now is why cant you compare YYYY or YYYYMM or QTR, it seems it has to be a YYYMMDD format