Splunk Search

How to calculate page bounce rate as a single value percentage?

ashnet16
Path Finder

I'm trying to display bounce rate as a single value percent. Does anyone have any idea on how I can do it?
As of of, i'm displaying the count of bounces. Thanks in advanced!

sourcetype=access_* | transaction clientip maxpause=1h keepevicted=t mvlist=t | eval bounce_count=case(eventcount=1,"Bounced")|stats count(bounce_count) as "Total page Bounces"| eval total_trans=case(eventcount>=1,"Total Visits")| eval bounce_rate= bounce_count/total_trans

Tags (2)
0 Karma

aweitzman
Motivator

Do you mean something like:

<your search> | eval bounce_rate_as_percent=tostring(round(bounce_rate*100))."%"

0 Karma
Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...