Can I use like this :
| eval a=if(Location!=" ",stat count by Location)
but I am getting error..
actually I want to find..I want to get the count for those records which are non-blank
Please help
I am not sure that you can use conditional searches, just conditional field calculation using eval.
another way is to make sure that the field location exits, then count | WHERE NOT ( Location=" " OR isnull(Location) ) | stat count by Location
| WHERE NOT ( Location=" " OR isnull(Location) ) | stat count by Location
You could also include it in the stats command directly:
stats count(eval(Location==" " OR isnull(Location))
