Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Counting Abandoned Flows

Hello All, Thanks for looking in to my post. I am struggling to find a better solution for below problem.    Data: mud_id visitor_id session_id Time stamp Page Name sk4844625 523012 2...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    6 years ago

    Hi, Anonymous 

     

    Based on my research, you may try the following measures.

     

    totalflowforuser = 
COUNTROWS(
    FILTER(
        ALL('Table'),
        'Table'[Page Name] = "Projects Page"&&
        'Table'[mud_id] = MAX('Table'[mud_id])
    )
)

completedflows = 
COUNTROWS(
    FILTER(
        ALL('Table'),
        'Table'[Page Name] = "Hit Connect"&&
        'Table'[mud_id] = MAX('Table'[mud_id])
    )
)

abandonedflows = 
COUNTROWS(
    FILTER(
        ALL('Table'),
        'Table'[Page Name] = "Select API environment"&&
        'Table'[mud_id] = MAX('Table'[mud_id])
    )
)-[completedflows]

notflow = 
[totalflowforuser]-[completedflows]-[abandonedflows]

     

     

    Result:

     

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi, Anonymous 

 

Based on my research, you may try the following measures.

 

totalflowforuser = 
COUNTROWS(
    FILTER(
        ALL('Table'),
        'Table'[Page Name] = "Projects Page"&&
        'Table'[mud_id] = MAX('Table'[mud_id])
    )
)

completedflows = 
COUNTROWS(
    FILTER(
        ALL('Table'),
        'Table'[Page Name] = "Hit Connect"&&
        'Table'[mud_id] = MAX('Table'[mud_id])
    )
)

abandonedflows = 
COUNTROWS(
    FILTER(
        ALL('Table'),
        'Table'[Page Name] = "Select API environment"&&
        'Table'[mud_id] = MAX('Table'[mud_id])
    )
)-[completedflows]

notflow = 
[totalflowforuser]-[completedflows]-[abandonedflows]

 

 

Result:

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Allan,

Thank you. This dax solution is great. I even applied it my original data. 

Only doubt i have at this point is,

Is there a way to force flow of events and then say its an abandoned flow(At present we are considering only "Select API environment" , but is there a way if the order as below, then its a abandoned flow..

Projects Page
Click on A Project - Project1
Click on "Connect an API (bottom right on Project)
API catalog page
Select an API - API details page
Connect to Project button
Select API environment

Thanks,

Siva