Data Studio
2.5K members online now
2.5K 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