How to sum 2 percent ?

[mah]

Hi,

I have a table like that : 

name	percent
AAA	90
BBB	60 70

I want to group the BBB percent in one percent.

How I can do this command ? 

Thanks

[ITWhisperer]

How do you want to "group" them? Add them together, multiply them together, take an average, join them with a space/comma between?

[mah]

Sorry, I want to average them.

[ITWhisperer · Accepted solution]

-- your search
| streamstats count as row
| eventstats sum(percent) as total by row
| eval percent=round(total/mvcount(percent),2)
| fields - row total