Hi all,
I am trying to find the average number of bytesOut for proxy activity by user. Obviously first I am pulling the number of bytesOut and all the users, so I get this:
user bytesOut
brian 100
michael 50
tom 75
My issue is that users have multiple requests, giving them multiple rows in this table, as seen here:
user bytesOut
brian 100
brian 100
michael 50
michael 50
michael 50
tom 75
I would like to combines the total number of bytesOut PER user (so brian's bytesOut=200) and then calculate whatever I need to on those fields. It's been a while since statistics class! Any help is appreciated.
Thanks,
B
'... | stats sum(bytesOut) as totalBytesOut by user | table user totalBytesout'
'... | stats sum(bytesOut) as totalBytesOut by user | table user totalBytesout'
I'm justifying my brainfart to "it's friday"