Splunk Enterprise Security

Calculate Percentage of Packets

abhik1501
New Member

So i have a splunk query that returns the below output

IP Packets
1.1.1.1 100
1.1.1.2 200
400
200
1.1.1.3 100
100
100
200
400
200
200
400
But i want to know what is the percentage of each packet size per IP

0 Karma

Sukisen1981
Champion

What is the desired output?
for ip 1.1.1.1 its 100/100=100%
and for 1.1.1.2 for the first row it is 200/800=25%?

0 Karma
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!