I have a table of data that shows activity in relation to users web activity and I need to establish a time spent on each page for each user.

My data has
  • User name
  • Time landed on the page
  • Any Links clicked on the page

As I have the time the user landed on the page via the link clicked I need to use a MAX function with FILTER to filter for the same Username, the same date and then the maximum time stamp prior to that rows time stamp.

At the moment I am using
but this return an empty result.