Date range comparison
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.
Date range comparison[ Edited ]
April 2017 - last edited April 2017
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