Last 6 months - Line Chart

[Anonymous]

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)

[sinanozdemir]

Hi,

Could be. Try to put Max() function in a Date(Max(MC_SERVICE_DATE_YYYYMM), 'Your Date Format')

[Anonymous]

Can you provide an example of how the full expresion should look?

[Anonymous]

The sums are correct but my current expression is not displaying only 6 months/values

[sinanozdemir]

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)

[Anonymous · Accepted solution]

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.

[jonas_rezende]

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!