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!

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

If you’re unfamiliar, .conf is Splunk’s premier event where the Splunk community, customers, partners, and ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...