Group count percentage by key

[xiangli9]

We have 5 host and 3 on west 2 on east, and each of them take x% of request, the stats we have right now looks like:

host                |      percentage 

ip-1-west.    |        15

ip-2-west.    |.        15

ip-3-west.    |.         20

ip-4-east.     |.         20

ip-50-east   |.         30

Now I'm trying to group the percentage by east and west so I can have the statics like:

host      |      percentage 

west.    |         50

east.     |         50

Can someone help me with this?

[anilchaithu]

@xiangli9 

try this

base search | rex field=host "^.*-(?P<host>\w+)$" | stats sum(percentage) as percentage by host

Hope this helps