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

Funnel Dashboard and UserIds

Malaik
DynaMight Mentor
DynaMight Mentor

Hi Community

 

I built a Funnel Dashboard that Working fine, but now I want to retrieve in a second tile the User Ids for each step,

If any one build this before, his help is appreciated.

Malaik_0-1662544268039.png

 

Have a good day

 

Sharing Knowledge
5 REPLIES 5

mark_bley
Dynatrace Mentor
Dynatrace Mentor

Hi @Malaik

in order to get specific userIds for a useraction you can use a query like this one:

SELECT DISTINCT userId as 'Current Unique UserID' FROM usersession Where (useraction.name = "Submit PE Products" and userId IS NOT NULL)

Best,

Mark

 

Malaik
DynaMight Mentor
DynaMight Mentor

Thank @mark_bley 
This is not what I need,

 

I need for each step exactly.

This request is given a different values.

Sharing Knowledge

mark_bley
Dynatrace Mentor
Dynatrace Mentor

So with above query the results would look something like this

mark_bley_0-1663577209142.png

which show you in a second tile the user Ids (count or list) for each step

Malaik
DynaMight Mentor
DynaMight Mentor

Yes

 

I built the same but the numbers are not matching that why i opened this discussion.

Sharing Knowledge

mark_bley
Dynatrace Mentor
Dynatrace Mentor

Hi @Malaik,

the numbers do not need to match necessarily from one step to the other.

What numbers are you seeing that would not expect ?

I would like to understand this issue better to help you out.

Best,

Mark