Show last 13 months as a calculated dimension

[hmjason7]

Hello,

I am trying to show just the last 13 months as a calculated dimension in a Month-Year format for a chart, but it doesn't seem to work.

My MonthYear field is created by the following expression:

Date(MakeDate(Year(MyDateField), Month(MyDateField),1), 'MMM-YY') as MonthYear

Do I create the expression as a calculated dimension or should it be done as a set analysis expression?

If so, what expression should I use?

Cheers,

Jason

[#2 · Accepted solution]

Jason,

I would create the Attribute for Month year in script:

Date(Date#(MyDateFeild,'MMM-YY) ,'MMM-YY') as MonthYear

Then limit data in set analysis expression

Here is qvw to show example

[hmjason7]

Thanks Shawn - works like a charm.