Hey @monitoringteam1 ,
You could extract a list of page loads from the user sessions data and apply a Distinct filter to eliminate duplicates.
Is your query returning an error or a null values? When I use the SELECT "page" it returns an error. so I used "useraction.name" instead of "page" and "useraction" instead of "userevent"
I tried a query like below:
SELECT DISTINCT useraction.name FROM useraction WHERE name STARTSWITH "Loading"
That returned all of the various page loads that the users are performing. Note: that it might differ if you have user action naming set up differently than I do.
Yes, that worked for me locally. If you expand the time you are looking at does it return any data?
If you don't get anything still and you can see data for the same time period in Pages then I would ask on chat for assistance.