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.
Answer by Joshua P. ·
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
Confluent integration with Dynatrace 1 Answer
User session export via pull 1 Answer