if-else condition

[abhayneilam]

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

[yannK]

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

[Ayn]

You could also include it in the stats command directly:

stats count(eval(Location==" " OR isnull(Location))