10 Replies Latest reply: Jun 18, 2015 5:43 AM by AVIRAL NAG RSS

    Pull data for the last 7 days in Dimension

    Hasvine Dhurmea

      Hello All,

       

      I am trying to pull out only the last 7 days in a calculated dimension and it says the expression is OK but it does not give me any data.

      Below is my calculated dimension:

       

      =if(Date >= today()-7 and Date = today(), Date)

       

      Date is my field name for date.

       

      Thanks for your help.

       

      Kind Regards,

       

      Hasvine