I have a table:
PageID, UserName, Date, count of hits to that page,
I would like to find the average daily page hits , per article at a UserID level. (for the top 100 most frequently viewed pages)
So for example, Person xyz , on average views page x , n number of times per day over the last week.
This is the start of the query...
... | bucket span=1d _time| stats count by PageID, UserName , _time | sort - count |head 100
Any help much appreciated.
... View more