5 Replies Latest reply: Sep 5, 2014 4:49 AM by Andy Weir RSS

    Month to Date

    sally Mains

      How would one get Month to date?


      I have a "customer", "search", "currentDate"


      I am trying to get a count of search that equal 'true' per customer month to date.  So like today being 9/4 I would want this count to be for all true for 9/1, 9/2, 9/3 and 9/4.


      I have "customer" picked as a dimension.


      and have tried

      COUNT({<search = {'true'} , CurrentDate = {'$(=Date(Month()))'}>}search)

      I have also tried pulling out the Month in my LOAD "CurrentMonth" and put that in the place of CurrentMonth but that did not get me anywhere.