I am working with google analytics dataset in looker. I need to access the “hits.time” (start time of the page view). In order to get the “end time” of the page view, I need to get the “hits.time” (i.e. start time) of the next page view. These are off by a row. Any suggestions how I can create a dimension called “time_next” that is essentially the hits.time from the next page view in the sequence of page views.
In bigquery, I am able to do this by using this function:
LEAD(hits.time, 1) over(