Solved: No of users who complete and abandon the flows

Anonymous · ‎10-22-2019

Hi,

I am quite new to PowerBI. Struggling to find a solution for below problem. Pls need help.

From below screen shot, highlighted flow of events need to be validated in sequence. if these steps are in sequence and if User dont click connect, then its an abandoned flow. I need to count these abanded flows.

v-lili6-msft · ‎10-23-2019

HI, @Anonymous

For your case, you may try this way as below:

Step1:

Add a group column for each flow

Group index = RANKX(FILTER('Table','Table'[Page Name]="Select API environment"),[Time stamp],,DESC)

Step2:

Add a measure that combines all the page name for each group

flow = CALCULATE(CONCATENATEX(VALUES('Table'[Page Name]),[Page Name],,",",ASC),ALLEXCEPT('Table','Table'[Group index]))

Step3:

Use these two measure get your requirement:

Completed Flows = 
var _table=SUMMARIZE('Table','Table'[Group index],"_a",IF(SEARCH("Hit Connect",[flow],1,0)>0&&SEARCH("Select API environment",[flow],1,0)>0,1,0)) return
SUMX(_table,[_a])

Abandoned flows = 
var _table=SUMMARIZE('Table','Table'[Group index],"_a",IF(SEARCH("Hit Connect",[flow],1,0)=0&&SEARCH("Select API environment",[flow],1,0)>0,1,0)) return
SUMX(_table,[_a])

Result:

and here is sample pbix file, please try it.

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

View solution in original post

v-lili6-msft · ‎10-23-2019

hi, @Anonymous

You could use SEARCH Funtion in the count measure to count "User don't click connect"

for example:

= CALCULATE(COUNTROWS('Table 1'),FILTER('Table 1',SEARCH("connect",[Page_name],1,0)))

If you still have problem, please share some simple sample data and your expected output.

Regards,

Lin

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

Anonymous · ‎10-23-2019

Hi @v-lili6-msft thanks for your reply.

I am trying to reply, but its spaming out. I dont know why..Will try agin after few min

Anonymous · ‎10-23-2019

I think Search function just searches particular data value, but I need to check full flow.

Sample Data

mud_id	visitor_id	session_id	Time stamp	Page Name
sk4844625	523012	202020	10/22/19 10:30 AM	Projects Page
sk4844625	523012	202020	10/22/19 10:31 AM	Click on A Project - Project1
sk4844625	523012	202020	10/22/19 10:32 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202020	10/22/19 10:33 AM	API catalog page
sk4844625	523012	202020	10/22/19 10:34 AM	Select an API - API details page
sk4844625	523012	202020	10/22/19 10:35 AM	Connect to Project button
sk4844625	523012	202020	10/22/19 10:36 AM	Select API environment
sk4844625	523012	202020	10/22/19 10:37 AM	Hit Connect
sk4844625	523012	202020	10/22/19 10:38 AM	Projects Page
sk4844625	523012	202020	10/22/19 10:39 AM	Click on A Project - Project1
sk4844625	523012	202020	10/22/19 10:40 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202020	10/22/19 10:41 AM	API catalog page
sk4844625	523012	202020	10/22/19 10:42 AM	Select an API - API details page
sk4844625	523012	202020	10/22/19 10:43 AM	Connect to Project button
sk4844625	523012	202020	10/22/19 10:44 AM	Select API environment
sk4844625	523012	202020	10/22/19 10:45 AM	Projects Page
sk4844625	523012	202020	10/22/19 10:46 AM	Click on A Project - Project1
sk4844625	523012	202020	10/22/19 10:47 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202020	10/22/19 10:48 AM	API catalog page
sk4844625	523012	202021	10/22/19 11:19 AM	Select an API - API details page
sk4844625	523012	202021	10/23/19 11:20 AM	Connect to Project button
sk4844625	523012	202021	10/24/19 11:21 AM	Select API environment
sk4844625	523012	202021	10/25/19 11:22 AM	Projects Page
sk4844625	523012	202021	10/26/19 11:23 AM	Click on A Project - Project1
sk4844625	523012	202021	10/27/19 11:24 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202021	10/28/19 11:25 AM	API catalog page
sk4844625	523012	202021	10/29/19 11:26 AM	Select an API - API details page
sk4844625	523012	202021	10/30/19 11:27 AM	Connect to Project button
sk4844625	523012	202021	10/31/19 11:28 AM	Select API environment
sk4844625	523012	202021	11/1/19 11:29 AM	Hit Connect
sk4844625	523012	202021	11/2/19 11:30 AM	Projects Page
sk4844625	523012	202021	11/3/19 11:31 AM	Click on A Project - Project1
sk4844625	523012	202021	11/4/19 11:32 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202021	11/5/19 11:33 AM	API catalog page
sk4844625	523012	202021	11/6/19 11:34 AM	Select an API - API details page
sk4844625	523012	202021	11/7/19 11:35 AM	Connect to Project button
sk4844625	523012	202021	11/8/19 11:36 AM	Select API environment
sk4844625	523012	202021	11/9/19 11:37 AM	Projects Page
sk4844625	523012	202021	11/10/19 11:38 AM	Click on A Project - Project1
sk4844625	523012	202021	11/11/19 11:39 AM	Click on "Connect an API (bottom right on Project)

Anonymous · ‎10-23-2019

From above test data:

Full Flow:

After Select API environment ,click on Hit Connect - (This is a completed valid 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

Hit Connect

Abandoned Flow:

After Select API environment ,there is NO Hit Connect, which means 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

Based on main table,

Expected results is a Measure: 3 Abandoned flows , 2 Completed Flows.

Pls Note: There is a chance events(rows) can flow to Next session.

v-lili6-msft · ‎10-23-2019

HI, @Anonymous

For your case, you may try this way as below:

Step1:

Add a group column for each flow

Group index = RANKX(FILTER('Table','Table'[Page Name]="Select API environment"),[Time stamp],,DESC)

Step2:

Add a measure that combines all the page name for each group

flow = CALCULATE(CONCATENATEX(VALUES('Table'[Page Name]),[Page Name],,",",ASC),ALLEXCEPT('Table','Table'[Group index]))

Step3:

Use these two measure get your requirement:

Completed Flows = 
var _table=SUMMARIZE('Table','Table'[Group index],"_a",IF(SEARCH("Hit Connect",[flow],1,0)>0&&SEARCH("Select API environment",[flow],1,0)>0,1,0)) return
SUMX(_table,[_a])

Abandoned flows = 
var _table=SUMMARIZE('Table','Table'[Group index],"_a",IF(SEARCH("Hit Connect",[flow],1,0)=0&&SEARCH("Select API environment",[flow],1,0)>0,1,0)) return
SUMX(_table,[_a])

Result:

and here is sample pbix file, please try it.

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

Anonymous · ‎10-24-2019

Hi @v-lili6-msft

The solution works perfect, my mistake,got confused with complex data.

Just one doubt:

Lets assume we have

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

Hit Connect

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

Is it possible to group them, I mean Grouping should start from "Projects Page" and end at "Hit Connect", if "Hit Connect", not there means previous one. Request your suggestion on making this work.thanks

Regards,

Siva

Anonymous · ‎10-24-2019

Sorry, Also from the solution you shared, if a new users comes in between and starts using website, Group indexing was getting messed

Group index = RANKX(FILTER(data,data[Page Name]="Select API environment"),[Time stamp],,DESC)

some where in above code , i need to include visitor_ID, so that grouping will be unique and visitor filter

I tried using ALLEXCEPT in side RankX, but returning error. pls suggest

Thanks in advance

regards,

Siva

Anonymous · ‎10-24-2019

hI @v-lili6-msft Thank you so much for your help. This solution is very good.

But I am struggling when I add this to original data.

My mistake,I should have given with more data, normally in my project, there is a possiblity different visitors comes to the website and hence group index will get mess up.

Is there a possiblity to include Ranking/indexing based on vistor ID +Is it possible to give starting point to indexing? like Indexing should start from "Projects Page"(Step 1).

Myself trying this from morning, still struggling.

Again, thanks for your help.

Regards,

Siva

Anonymous · ‎10-23-2019

Thanks Lin for your reply.

I think Search function just searches particular data value, but I need to check full flow.

Sample Data

mud_id	visitor_id	session_id	Time stamp	Page Name
sk4844625	523012	202020	10/22/19 10:30 AM	Projects Page
sk4844625	523012	202020	10/22/19 10:31 AM	Click on A Project - Project1
sk4844625	523012	202020	10/22/19 10:32 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202020	10/22/19 10:33 AM	API catalog page
sk4844625	523012	202020	10/22/19 10:34 AM	Select an API - API details page
sk4844625	523012	202020	10/22/19 10:35 AM	Connect to Project button
sk4844625	523012	202020	10/22/19 10:36 AM	Select API environment
sk4844625	523012	202020	10/22/19 10:37 AM	Hit Connect
sk4844625	523012	202020	10/22/19 10:38 AM	Projects Page
sk4844625	523012	202020	10/22/19 10:39 AM	Click on A Project - Project1
sk4844625	523012	202020	10/22/19 10:40 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202020	10/22/19 10:41 AM	API catalog page
sk4844625	523012	202020	10/22/19 10:42 AM	Select an API - API details page
sk4844625	523012	202020	10/22/19 10:43 AM	Connect to Project button
sk4844625	523012	202020	10/22/19 10:44 AM	Select API environment
sk4844625	523012	202020	10/22/19 10:45 AM	Projects Page
sk4844625	523012	202020	10/22/19 10:46 AM	Click on A Project - Project1
sk4844625	523012	202020	10/22/19 10:47 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202020	10/22/19 10:48 AM	API catalog page
sk4844625	523012	202021	10/22/19 11:19 AM	Select an API - API details page
sk4844625	523012	202021	10/23/19 11:20 AM	Connect to Project button
sk4844625	523012	202021	10/24/19 11:21 AM	Select API environment
sk4844625	523012	202021	10/25/19 11:22 AM	Projects Page
sk4844625	523012	202021	10/26/19 11:23 AM	Click on A Project - Project1
sk4844625	523012	202021	10/27/19 11:24 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202021	10/28/19 11:25 AM	API catalog page
sk4844625	523012	202021	10/29/19 11:26 AM	Select an API - API details page
sk4844625	523012	202021	10/30/19 11:27 AM	Connect to Project button
sk4844625	523012	202021	10/31/19 11:28 AM	Select API environment
sk4844625	523012	202021	11/1/19 11:29 AM	Hit Connect
sk4844625	523012	202021	11/2/19 11:30 AM	Projects Page
sk4844625	523012	202021	11/3/19 11:31 AM	Click on A Project - Project1
sk4844625	523012	202021	11/4/19 11:32 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202021	11/5/19 11:33 AM	API catalog page
sk4844625	523012	202021	11/6/19 11:34 AM	Select an API - API details page
sk4844625	523012	202021	11/7/19 11:35 AM	Connect to Project button
sk4844625	523012	202021	11/8/19 11:36 AM	Select API environment
sk4844625	523012	202021	11/9/19 11:37 AM	Projects Page
sk4844625	523012	202021	11/10/19 11:38 AM	Click on A Project - Project1
sk4844625	523012	202021	11/11/19 11:39 AM	Click on "Connect an API (bottom right on Project)

From above test data:

Full Flow:

After Select API environment ,click on Hit Connect - (This is a completed valid 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

Hit Connect

Abandoned Flow:

After Select API environment ,there is NO Hit Connect, which means 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

Based on main table,

Expected results is a Measure: 3 Abandoned flows , 2 Completed Flows.

Pls Note: There is a chance events(rows) can flow to Next session.

Anonymous · ‎10-23-2019

Thanks @v-lili6-msft Lin for your reply.

I think Search function just searches particular data value, but I need to check full flow.

Sample Data

mud_id	visitor_id	session_id	Time stamp	Page Name
sk4844625	523012	202020	10/22/19 10:30 AM	Projects Page
sk4844625	523012	202020	10/22/19 10:31 AM	Click on A Project - Project1
sk4844625	523012	202020	10/22/19 10:32 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202020	10/22/19 10:33 AM	API catalog page
sk4844625	523012	202020	10/22/19 10:34 AM	Select an API - API details page
sk4844625	523012	202020	10/22/19 10:35 AM	Connect to Project button
sk4844625	523012	202020	10/22/19 10:36 AM	Select API environment
sk4844625	523012	202020	10/22/19 10:37 AM	Hit Connect
sk4844625	523012	202020	10/22/19 10:38 AM	Projects Page
sk4844625	523012	202020	10/22/19 10:39 AM	Click on A Project - Project1
sk4844625	523012	202020	10/22/19 10:40 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202020	10/22/19 10:41 AM	API catalog page
sk4844625	523012	202020	10/22/19 10:42 AM	Select an API - API details page
sk4844625	523012	202020	10/22/19 10:43 AM	Connect to Project button
sk4844625	523012	202020	10/22/19 10:44 AM	Select API environment
sk4844625	523012	202020	10/22/19 10:45 AM	Projects Page
sk4844625	523012	202020	10/22/19 10:46 AM	Click on A Project - Project1
sk4844625	523012	202020	10/22/19 10:47 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202020	10/22/19 10:48 AM	API catalog page
sk4844625	523012	202021	10/22/19 11:19 AM	Select an API - API details page
sk4844625	523012	202021	10/23/19 11:20 AM	Connect to Project button
sk4844625	523012	202021	10/24/19 11:21 AM	Select API environment
sk4844625	523012	202021	10/25/19 11:22 AM	Projects Page
sk4844625	523012	202021	10/26/19 11:23 AM	Click on A Project - Project1
sk4844625	523012	202021	10/27/19 11:24 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202021	10/28/19 11:25 AM	API catalog page
sk4844625	523012	202021	10/29/19 11:26 AM	Select an API - API details page
sk4844625	523012	202021	10/30/19 11:27 AM	Connect to Project button
sk4844625	523012	202021	10/31/19 11:28 AM	Select API environment
sk4844625	523012	202021	11/1/19 11:29 AM	Hit Connect
sk4844625	523012	202021	11/2/19 11:30 AM	Projects Page
sk4844625	523012	202021	11/3/19 11:31 AM	Click on A Project - Project1
sk4844625	523012	202021	11/4/19 11:32 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202021	11/5/19 11:33 AM	API catalog page
sk4844625	523012	202021	11/6/19 11:34 AM	Select an API - API details page
sk4844625	523012	202021	11/7/19 11:35 AM	Connect to Project button
sk4844625	523012	202021	11/8/19 11:36 AM	Select API environment
sk4844625	523012	202021	11/9/19 11:37 AM	Projects Page
sk4844625	523012	202021	11/10/19 11:38 AM	Click on A Project - Project1
sk4844625	523012	202021	11/11/19 11:39 AM	Click on "Connect an API (bottom right on Project)

From above test data:

Full Flow:

After Select API environment ,click on Hit Connect - (This is a completed valid 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

Hit Connect

Abandoned Flow:

After Select API environment ,there is NO Hit Connect, which means 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

Based on main table,

Expected results is a Measure: 3 Abandoned flows , 2 Completed Flows.

Pls Note: There is a chance events(rows) can flow to Next session.

Anonymous · ‎10-23-2019

Thanks @v-lili6-msft Lin for your reply.

I think Search function just searches particular data value, but I need to check full flow.

Sample Data

mud_id	visitor_id	session_id	Time stamp	Page Name
sk4844625	523012	202020	10/22/19 10:30 AM	Projects Page
sk4844625	523012	202020	10/22/19 10:31 AM	Click on A Project - Project1
sk4844625	523012	202020	10/22/19 10:32 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202020	10/22/19 10:33 AM	API catalog page
sk4844625	523012	202020	10/22/19 10:34 AM	Select an API - API details page
sk4844625	523012	202020	10/22/19 10:35 AM	Connect to Project button
sk4844625	523012	202020	10/22/19 10:36 AM	Select API environment
sk4844625	523012	202020	10/22/19 10:37 AM	Hit Connect
sk4844625	523012	202020	10/22/19 10:38 AM	Projects Page
sk4844625	523012	202020	10/22/19 10:39 AM	Click on A Project - Project1
sk4844625	523012	202020	10/22/19 10:40 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202020	10/22/19 10:41 AM	API catalog page
sk4844625	523012	202020	10/22/19 10:42 AM	Select an API - API details page
sk4844625	523012	202020	10/22/19 10:43 AM	Connect to Project button
sk4844625	523012	202020	10/22/19 10:44 AM	Select API environment
sk4844625	523012	202020	10/22/19 10:45 AM	Projects Page
sk4844625	523012	202020	10/22/19 10:46 AM	Click on A Project - Project1
sk4844625	523012	202020	10/22/19 10:47 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202020	10/22/19 10:48 AM	API catalog page
sk4844625	523012	202021	10/22/19 11:19 AM	Select an API - API details page
sk4844625	523012	202021	10/23/19 11:20 AM	Connect to Project button
sk4844625	523012	202021	10/24/19 11:21 AM	Select API environment
sk4844625	523012	202021	10/25/19 11:22 AM	Projects Page
sk4844625	523012	202021	10/26/19 11:23 AM	Click on A Project - Project1
sk4844625	523012	202021	10/27/19 11:24 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202021	10/28/19 11:25 AM	API catalog page
sk4844625	523012	202021	10/29/19 11:26 AM	Select an API - API details page
sk4844625	523012	202021	10/30/19 11:27 AM	Connect to Project button
sk4844625	523012	202021	10/31/19 11:28 AM	Select API environment
sk4844625	523012	202021	11/1/19 11:29 AM	Hit Connect
sk4844625	523012	202021	11/2/19 11:30 AM	Projects Page
sk4844625	523012	202021	11/3/19 11:31 AM	Click on A Project - Project1
sk4844625	523012	202021	11/4/19 11:32 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202021	11/5/19 11:33 AM	API catalog page
sk4844625	523012	202021	11/6/19 11:34 AM	Select an API - API details page
sk4844625	523012	202021	11/7/19 11:35 AM	Connect to Project button
sk4844625	523012	202021	11/8/19 11:36 AM	Select API environment
sk4844625	523012	202021	11/9/19 11:37 AM	Projects Page
sk4844625	523012	202021	11/10/19 11:38 AM	Click on A Project - Project1
sk4844625	523012	202021	11/11/19 11:39 AM	Click on "Connect an API (bottom right on Project)

From above test data:

Full Flow:

After Select API environment ,click on Hit Connect - (This is a completed valid 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

Hit Connect

Abandoned Flow:

After Select API environment ,there is NO Hit Connect, which means 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

Based on main table,

Expected results is a Measure: 3 Abandoned flows , 2 Completed Flows.

Pls Note: There is a chance events(rows) can flow to Next session.

Anonymous · ‎10-23-2019

Thanks Lin for your reply.

I think Search function just searches particular data value, but I need to check full flow.

Sample Data

mud_id	visitor_id	session_id	Time stamp	Page Name
sk4844625	523012	202020	10/22/19 10:30 AM	Projects Page
sk4844625	523012	202020	10/22/19 10:31 AM	Click on A Project - Project1
sk4844625	523012	202020	10/22/19 10:32 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202020	10/22/19 10:33 AM	API catalog page
sk4844625	523012	202020	10/22/19 10:34 AM	Select an API - API details page
sk4844625	523012	202020	10/22/19 10:35 AM	Connect to Project button
sk4844625	523012	202020	10/22/19 10:36 AM	Select API environment
sk4844625	523012	202020	10/22/19 10:37 AM	Hit Connect
sk4844625	523012	202020	10/22/19 10:38 AM	Projects Page
sk4844625	523012	202020	10/22/19 10:39 AM	Click on A Project - Project1
sk4844625	523012	202020	10/22/19 10:40 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202020	10/22/19 10:41 AM	API catalog page
sk4844625	523012	202020	10/22/19 10:42 AM	Select an API - API details page
sk4844625	523012	202020	10/22/19 10:43 AM	Connect to Project button
sk4844625	523012	202020	10/22/19 10:44 AM	Select API environment
sk4844625	523012	202020	10/22/19 10:45 AM	Projects Page
sk4844625	523012	202020	10/22/19 10:46 AM	Click on A Project - Project1
sk4844625	523012	202020	10/22/19 10:47 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202020	10/22/19 10:48 AM	API catalog page
sk4844625	523012	202021	10/22/19 11:19 AM	Select an API - API details page
sk4844625	523012	202021	10/23/19 11:20 AM	Connect to Project button
sk4844625	523012	202021	10/24/19 11:21 AM	Select API environment
sk4844625	523012	202021	10/25/19 11:22 AM	Projects Page
sk4844625	523012	202021	10/26/19 11:23 AM	Click on A Project - Project1
sk4844625	523012	202021	10/27/19 11:24 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202021	10/28/19 11:25 AM	API catalog page
sk4844625	523012	202021	10/29/19 11:26 AM	Select an API - API details page
sk4844625	523012	202021	10/30/19 11:27 AM	Connect to Project button
sk4844625	523012	202021	10/31/19 11:28 AM	Select API environment
sk4844625	523012	202021	11/1/19 11:29 AM	Hit Connect
sk4844625	523012	202021	11/2/19 11:30 AM	Projects Page
sk4844625	523012	202021	11/3/19 11:31 AM	Click on A Project - Project1
sk4844625	523012	202021	11/4/19 11:32 AM	Click on "Connect an API (bottom right on Project)
sk4844625	523012	202021	11/5/19 11:33 AM	API catalog page
sk4844625	523012	202021	11/6/19 11:34 AM	Select an API - API details page
sk4844625	523012	202021	11/7/19 11:35 AM	Connect to Project button
sk4844625	523012	202021	11/8/19 11:36 AM	Select API environment
sk4844625	523012	202021	11/9/19 11:37 AM	Projects Page
sk4844625	523012	202021	11/10/19 11:38 AM	Click on A Project - Project1
sk4844625	523012	202021	11/11/19 11:39 AM	Click on "Connect an API (bottom right on Project)

From above test data:

Full Flow:

After Select API environment ,click on Hit Connect - (This is a completed valid 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

Hit Connect

Abandoned Flow:

After Select API environment ,there is No Hit Connect, which means 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

Based on main table,

Expected results is a Measure: 3 Abandoned flows , 2 Completed Flows.

Pls Note: There is a chance events(rows) can flow to Next session.

No of users who complete and abandon the flows

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly