A) The ask is to find out which is the PAGE where most of the users EXIT from the application. In other words we want to find out the EXIT pages of all the users and then group by the pages to find their individual counts.
e.g: If there are 10 pages in an application which are accessed by 100 online users. We would like to know how many users EXITED our application after accessing Page 1, 2, 3 … & 10. And then we can find out which is the PAGE most of the users are EXITING from.
B) For a given user and a date time range we want to know the sequence of pages accessed by the user…
- User “John” accessed Page 1 -> Page 3 -> Page 6 -> Page 7 -> (Then logged out)
- User “Susan” accessed Page 1 -> Page 2 -> Page 4 -> Page 5 -> Page 10 -> (Then abruptly disconnected the session without logging out)