Archive
Highlighted

How do i get a % of page hits off the total users who accessed a set of pages.

New Member
index=app sourcetype=accesslog uri="some uri" user!="-"  (context="display" OR context="pages") earliest=-7d | rex field=page ^"(?<spacekey_or_action>\S+)(\/|\?|spaceKey\=|draftId\=|pageId\=|key\=)|(?<pid_or_sk>[0-9|a-z|A-Z|\+\%\-\:\(\)\.]{1,})|\&(?<article>\S+)" max_match=0 | search spacekey_or_action="123" OR (spacekey_or_action="viewpage.action" AND pid_or_sk="123")
|  stats dc(user) as users by page 
|  sort -users
|  eventstats sum(users) as totalUsers

I get the display as :

  1. Page1 100 150
  2. Page2 50 150

Basically, my question is how do i get a % so Page 1 is 66% of total events and Page 2 is 33% of total events and so on

The base rex and this followup rex searches all pages for the content group 123.

Tags (1)
0 Karma
Highlighted

Re: How do i get a % of page hits off the total users who accessed a set of pages.

SplunkTrust
SplunkTrust

@abhijitd ,

Just add this to your search

  | eval perc=round((users/totalUsers)*100,2)

View solution in original post

0 Karma
Highlighted

Re: How do i get a % of page hits off the total users who accessed a set of pages.

New Member

Thanks! this worked.

0 Karma