Is there any option to query user sessions that have actions in some consecutive order?
For example - an application has 3 actions - “action1”, “action2”, “action3”. These may appear in any order in a user session and they can also repeat. I need to have a list of sessions in which actions are in exact order - such as “action1” is followed by “action2” which is followed by “action3”.
It seems this cannot be achieved using USQL - can anyone confirm that? We can only filter sessions having particular actions, but regardless of their order.
Are you by chance asking about a Funnel for User Sessions? If so, in v1.182 of Dynatrace we’re launching USQL Funnels!
Here’s an example USQL query that provided the examples below:
SELECT FUNNEL(useraction.name="AppStart (easyTravel)" AS 'Open easytravel', useraction.name = "searchJourney" AS 'Search journey', useraction.name = "bookJourney" AS 'Book journey') FROM usersession
Well, until we get USQL working on live sessions, the usage will still be mostly for business analytics. It’s not very useful for realtime or near-real-time monitoring of user experience - live session may take up to several hours to finalize and included in USQL results.
Hi Joshua, why your mentioned blog doesn’t contain info about FUNNEL functionality ? I have already tried it and it looks nice. Even dynatrace documentation is extended with info about this functionality so i wonder why it’s so “hidden” in news.
Once we write the USQL query using Funnel, it is not showing in Dashboard as “Y” shape of Funnel details like user action name details with count and % of completion?
Showing above Funnel look is not good to see in dashboards.