Date as variable in a set analysis

Anonymous — Wed, 30 May 2018 13:01:35 GMT

Hello.

I'd like to compare the sales between a certain date (YYYY-MM) and the same period but a year before.

This certain date is a manually typed variable named MonthA.

I've been able to graph the sales of that exact month with the following expression, even thought it says 'Error in expression':

sum({$<time.MonthYear={'$(=date(date#(MonthA,'YYYY-MM'),'YYYY-MM'))'}>} Sales).

I've tried using two manually typed variables, MonthA and MonthB and it works but I'd like to accomplish the same with an expression.

sum({$<time.MonthYear={'$(MonthA)','$(MonthB)'}>} Sales)

I've tried using addyears(date(date#(MonthA,'YYYY-MM'),'YYYY-MM')),-1) but it doesn't work. Could you help me out?

Thanks a lot.

Re: Date as variable in a set analysis

Anonymous — Wed, 30 May 2018 14:18:59 GMT

I've solved it after going to Settings >> Variable Overview and setting MonthB as =NUM(LEFT('$(MonthA)',4)-1)&'-'&RIGHT('$(MonthA)',2).