5 Replies Latest reply: Aug 12, 2015 2:33 AM by arjun rao RSS

    Month filter

    Hasvine Dhurmea

      Hello All,

       

      I have a table where I need to pull the data for the month. I am actually using a filter but I need to make the table dynamic.

       

      In my load script I convert the date field into month as follows:

       

      Month(Floor(CallUniversalTime)) AS Mois,

       

      Do you guys have an expression which I can use in my Dimension to pull the data of the current month only.

       

      Thanks,

       

      Hasvine