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(

          aggr

            ( (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.

       

      Thanks