How do I divide a columns number by two?

[elijahm]

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

[richgalloway · Accepted solution]

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