This content has been marked as final. Show 2 replies
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?