Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Counting values in one column based on string filters from another column

Hello,    I have a table name tableA with  date                    user id            event xx/xx/xxxx           abcdef            step 1 xx/xx/xxxx           abcdef            step 2 xx/xx/xxx...
Migasuke's avatar
Migasuke
Memorable Member
5 years ago

Hi Anonymous ,

Please could you tell me, what result would you expect in case of user ID "abcdef"  and "abdjfe"?
Just to be sure, we are on the same page.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Migasuke 

The result should look something like this (essentially with a Funnel Charts): 

Funnel Chart 1

Step 1      2

Step 2      2

Step 3      2

Step 4      1

 

Each user id can complete different steps so based on their previous events. So For example, if one user completes Step 1, there will be two options to choose from on Step 2. Based on their selection, it will take them to either Step 3 or Step 4. But eventually, everyone gets to Step 5 so I want to see which route is popular. 

  • Migasuke's avatar
    Migasuke
    Memorable Member
    5 years ago

    Hi Anonymous ,

    In that case I think this is the measure you are looking for:

    Let me know, if that helps!