Select a specific element within the useraction.name array

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?

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.

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