Select a specific element within the useraction.name array

[loopy]

When performing the User Session Query select useraction.name from usersession the names of the actions are returned in what looks like an array. The problem statement is I would like to know after the home page where users next navigate to eg useraction.name[1]. Is there a way to split these out in this query format, or can it be done/ needs to be done using js code and an API call?

[tomaxp]

In USQL, useraction.name is a multi-value field. It renders like an array, but USQL doesn’t support positional indexing (there’s no useraction.name[1]) and it can’t reliably preserve action order. If you need “what came next after Home?”, USQL alone can’t do that. The only thing you can do is use a funnel. But in a funnel, you have to define the steps yourself.

[tomaxp]

You can also export user sessions to another tool and process them there, using the user session export.
https://docs.dynatrace.com/docs/observe/digital-experience/session-segmentation/export-session-data