Last usage of a URL

You can proceed as follows:

1. Select the Page Event Explore.
2. Add the following fields:
   • User
   • URL
   • Timestamp
3. Add a Table Calculation with the following formula. Name it, for example, Latest Event:

row() = 1 OR ${page_event.user} != offset(${page_event.user}, -1)

4. Configure the sorting in the following order:
   • User: Ascending
   • Timestamp: Descending
5. On the Latest Event column, click the gear icon and select Hide “No”s in visualization.

As a result, only the most recent Page Event for each user will be displayed.