cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

USQL - Funnel by userId

MAkimov
Mentor

as I understand correctly, the funnel function is based on a user session

is it possible to build a funnel based on unique users?

for example, when a user starts a process, but within one session does not end it. And then, for example, tomorrow he will start filling out the process again.

We need Funnul based uniq user not usersession

4 REPLIES 4

ChadTurner
Leader

While I have not tried this, its worth a shot. Did you try and were you unable to make a funnel chart based off of a single user?

-Chad

JamesKitson
Dynatrace Leader
Dynatrace Leader

You can filter down to a specific user tag in a funnel/usql but all of the funnel queries work at the session level so you can't span multiple sessions (over several days for example) when populating a funnel.

Hi Mikhail.

Yes, you right, funnel based on sessions. but you can use Single value in USQL to see that values on your dashboard.

it will looks like this

where three tiles at the bottom will contain something like this:

1. SELECT COUNT(userid) as users FROM usersession WHERE useraction.name = "AppStart (easyTravel)"

2. SELECT COUNT(userid) AS users FROM usersession WHERE useraction.name = "AppStart (easyTravel)" and useraction.name = "searchJourney"

3. SELECT COUNT(userid) AS users FROM usersession WHERE useraction.name = "AppStart (easyTravel)" and useraction.name = "searchJourney" AND useraction.name = "bookJourney"

Probably you got to use COUNT(DISTINCT userid) instead of COUNT(userid) to exclude dublicates

have a question

will this select show users who had the first action in one session and the second in another, or will it show users who had two actions in one session

SELECT COUNT(userid) AS users FROM usersession WHERE useraction.name = "AppStart (easyTravel)" and useraction.name = "searchJourney"