I have these 3 stats count searches, but I would like to combine them as one and create a table.
host ="web*" source="Access" "men" | stats dc(id) by city host ="web*" source="Access" "women" | stats dc(id) by city host ="web*" source="Access" | stats dc(id) by city
My objective is to have the number for men, women, and total (men+women)
host ="web*" source="Access" | eval type = case(searchmatch("men"), "All,Men", searchmatch("women"), "All,Women", true(), "All,Neither") | makemv delim="," type | chart dc(id) over city BY type
thank you so very much, quick question, do you mind if you can explain to me what's the purpose of "Neither"? also the total count for (men+women) by each city rather than total (men/women total. sorry I think my question was wrong earlier.
OK, I tweaked my answer a bit. I realized that since we are using
dc instead of
count, that using
addtotals is invalid. So I switched to creating a value for
All that will allow us to
dc all events. As far as "Neither", there may be some events that have neither "men" nor "women" so this captures those. It is quite possible that "Neither" will always be zero but it is good to check, just in case. Also, I had the 2 fields' (
type ) positions swapped so the table was built backwards. I fixed it and it should look like what you are desiring now.