I currently use the following to count the number of names that are tagged as cool:
... tag::cool | stats dc("Name")
This gives me a count of cool kids. I would like to compare the number of kids that are "cool" with those that are not cool. Any ideas how I can get those two numbers?
you can do something like this:
tag::cool OR tag::uncool | stats count(eval(tag="cool")) AS cool count(eval(tag="uncool")) AS uncool count AS total
to get a count of cool things, uncool things and a total count of both events.
Just in case there is no
tag::uncool you can use this search:
tag::* OR NOT tag::* | stats count(eval(tag="cool")) AS cool sum(eval(if(isnull(tag), 1, 0))) AS uncool count AS total
Hope this helps ...
hmm, maybe I did misunderstood your question.... do you have a
tag::uncool or only a tag for