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

abhijitd — Wed, 04 Sep 2019 01:12:06 GMT

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 :

Page1 100 150
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.

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

renjith_nair — Wed, 04 Sep 2019 07:51:31 GMT

@abhijitd ,

Just add this to your search

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

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

abhijitd — Wed, 04 Sep 2019 13:06:05 GMT

Thanks! this worked.

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

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

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

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