Splunk Search
Highlighted

Count total number of male or female in given country

New Member

Gender . About Right . Oveight . underweight country
f . 560 163 37 USA
m 295 . 72 . 73 . USA

toal . 855 235 . 110

Tags (3)
0 Karma
Highlighted

Re: Count total number of male or female in given country

Legend

Provided your base search returns the fields mentioned by you. Following should be your search:

 <Your Base Search>
| stats sum("About Right") as AboutRight sum(Overweight) as Overweight sum(underweight) as Underweight by Gender, country 
| addcoltotals AboutRight Overweight Underweight labelfield=Gender



| eval message="Happy Splunking!!!"


View solution in original post

0 Karma