Multiple conditions in filter

  • Resolved elbopa

    (@elbopa)


    10 years, 3 months ago

    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?

    https://www.ads-software.com/plugins/wp-slimstat-shortcodes/

Viewing 3 replies - 1 through 3 (of 3 total)
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Multiple conditions in filter’ is closed to new replies.