Archive

How do I divide a columns number by two?

Explorer

The code belows displays a column showing the amount of times the string "GetPolicy.doPost(56)" occurs. I want to divide this number of occurrences by two and I'm not too sure how to go about doing this. Thanks!

index=client_snsr_tcg_unix_webservices source="/var/log/tomcat8/catalina.out" "GetPolicy.doPost(56)"
| stats count(eval(like(_raw,"%GetPolicy.doPost(56)%"))) as "GetPolicy.doPost(56)" by date_month

Tags (1)
0 Karma
1 Solution

SplunkTrust
SplunkTrust

Try adding | eval "GetPolicy.doPost(56)" = 'GetPolicy.doPost(56)' / 2 to the end of the query.

---
If this reply helps you, an upvote would be appreciated.

View solution in original post

0 Karma

SplunkTrust
SplunkTrust

Try adding | eval "GetPolicy.doPost(56)" = 'GetPolicy.doPost(56)' / 2 to the end of the query.

---
If this reply helps you, an upvote would be appreciated.

View solution in original post

0 Karma