Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a data set that looks like :
Date Sales .... .... .....
1/20/2014 100
1/19/2014 200
1/18/2014 300
1/17/2014 400
1/16/2014 500
1/15/2014 600
1/14/2014 700
1/13/2014 800
1/12/2014 900
Trying to create a "Same Day Last Week Expression"
Date Sales Last Week
1/20/2014 100 800
1/19/2014 200 900
1/18/2014 300
1/17/2014 400
1/16/2014 500
1/15/2014 600
1/14/2014 700
1/13/2014 800
1/12/2014 900
I can not get the Set analysis to work.(sum({$<date = {$(lw_date)}>} sales )
I appreciate any help.
Hey Amir,
Please check out the attached file. I did everything on the backend.
Hope it helps
Thanks
AJ
Hey Amir,
Please check out the attached file. I did everything on the backend.
Hope it helps
Thanks
AJ
Thank you so much Ajay, this is very clever. I really appreciate your help.
Another option is
=Below(Sum(ActualSales),7)
You could also try something like:
sum ({$< date = {'$(=date(today(0)-7))'}>} sales)
You could also set a date variable and call it in the set analysis, for instance:
let vSameDayLastWeek = date(today()-7);
Then the set would be:
sum({$< date = {'$(vSameDayLastWeek)'} >}sales )
Best,
Matt
This also worked. PERFECT
Thanks