Since I am new to Splunk is there is demo query for calculating this will be helpful,Basically, i want to count one field multiple times with the different condition
lets imagine you have a field called fruit and it has 3 unique values apple,banana,mango
you can do this: ... search for your fruit field ... | stats count by fruit
you can also do this: ... search for your fruit field ... | stats count(eval(fruit="apple") as apples count(eval(fruit="banana")) as bananas count(eval(fruit="mango")) as mangos ....
