6 Replies Latest reply: Dec 21, 2016 7:15 AM by Vineeth Pujari RSS

    Max Date field  - 7 on if statement?

    ben lim

      Hi I have this following expression below to calculate the # of orders that check in on the date itself


      count(DISTINCT if(


            ( (Order_Date= Check_In_Date,Order_No),Order_No))


      I need to include a condition like the statement below where it look @ rolling 7 days


      Count(DISTINCT{<Order_Date= {'>=$(=date(max(all Order_Date)-7))'}>} (Order_No))


      How can I use Max Date rolling 7 days on if?


      Remember that I can only do on expression, not on dimension and script.