Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
count({$ <search={true} , CurrentDate={">=$(=MonthStart(Today()))<=$(=Today())"}>} search)
Thank you for the reply. I tried this and it is just giving me 0 for everything. Any ideas?
I think your issue is you are treating true/false as text rather than 1/0 i've attached a sample.
That didn't load here are some screen shots
you need to filter on 1 rather than true to fix your issue.
Here is the example. Hope this helps.