How can I count which different lines

[keyu921]

My Data as following
AA || Disabled || Region
[email protected] || Yes || HK
[email protected] || No || US
[email protected] || No || US
[email protected] || No || UK
[email protected] || Yes || UK
[email protected] || No || UK
[email protected] || No || UK
[email protected] || No || HK
[email protected] || Yes || HK

I would like to count as following
% of account disable and enable in different region

| stats count(eval(status=="No")) as var1 by CountryRegion, count(eval(status=="Yes")) as var2 by CountryRegion ???

[ragedsparrow · Accepted solution]

<base search>
| stats count as Count by Region, Disabled
| eventstats sum(Count) as Total by Region
| eval "State Percentages"=round(Count*100/Total,2) | fields - Total

Would something like this work?