Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Per other blogs I have the below expression. I would like to only display the lattest 6 months.
Current Expression that I'm using below but nothing has changed. Could it be that MC_SERVICE_DATE_YYYMM is not in a date format?
SUM({<MC_SERVICE_DATE_YYYYMM={'>$(=AddMonths(Max(MC_SERVICE_DATE_YYYYMM),-6))'}>} TOTAL_PHONE_CONTACTS)
My dimesion is not a date. I was able to only display x values by using the Dimesion Limits tab to show FIRST x values, worked great.
Hi,
Could be. Try to put Max() function in a Date(Max(MC_SERVICE_DATE_YYYYMM), 'Your Date Format')
Can you provide an example of how the full expresion should look?
The sums are correct but my current expression is not displaying only 6 months/values
Since I don't know your date format, but you can use 'MM/DD/YYYY' or 'YYYY-MM-DD' in 'Your_Date_Format' field. This should work:
SUM({<MC_SERVICE_DATE_YYYYMM={'>$(=AddMonths(Date(Max(MC_SERVICE_DATE_YYYYMM),'Your_Date_Format'),-6))'}>}TOTAL_PHONE_CONTACTS)
My dimesion is not a date. I was able to only display x values by using the Dimesion Limits tab to show FIRST x values, worked great.
Try:
SUM({<MC_SERVICE_DATE_YYYYMM={">$(=AddMonths(Max(MC_SERVICE_DATE_YYYYMM),-6))"}>} TOTAL_PHONE_CONTACTS)
or
SUM({<MC_SERVICE_DATE_YYYYMM={">$(=Date(AddMonths(Max(MC_SERVICE_DATE_YYYYMM),-6)))"}>} TOTAL_PHONE_CONTACTS)
Anyway, replace simple quote for double-quote.
Hope this helps!