Multiple conditions in filter
-
Our site has lots of visitors from 4 countries, and a few visitors from lots of different countries, which I want to lump into Other, or visitors where country is_not_equal_to any of the main 4.
But while
[slimstat f=’count’ w=’ip’ lf=’day equals today&&&country is_not_equal_to ch’]
excluding Switzerland gives the correct result,
[slimstat f=’count’ w=’ip’ lf=’day equals today&&&country is_not_equal_to ch&&&country is_not_equal_to fr’]
only seems to exclude France, or whatever the last country in the Where clause is. I can’t include all 4 countries in the filter.
Using WHERE: works for excluding the 4 countries, but then I can’t seem to get just today’s visitors. WHERE:DATE(dt) = DATE(NOW()) or even DAY returns nothing even when f=’count-all’.
This should not be so hard!
Has anyone had more luck with the WHERE: method and visitor dates?
- The topic ‘Multiple conditions in filter’ is closed to new replies.
