Visualizing customer journey through a chart (different paths)

[Momo34]

Hi Everyone,

I would like to analyse the customer journey of the users of a website by having all the different path combinations that have been followed 

Ideally I would like to  have it in a table : 

Path combination	Number of CustomerID
homepage+pagexxxx+pagexx+pagex	4,445
pagex+pagexxxx+pagexxxx	350
pagexxx+pagexxx	54

and also to get a chart like this:

The data that I have are like this and I would like to know how to transform the data to get this chart or at least a table with the list of the path combinations and its number of users, and also the average of time it takes to move from pagexxx to pagexxxxx

EventID	Customer	Event DateTime	Page
35353	1	15/10/2019 06:30:25	pagexxxx
94464	1	15/10/2019 06:31:15	pagexx
3653434	1	15/10/2019 06:34:02	pagexxxx
10187353	2	15/10/2019 06:30:05	pagexxxx
3938364545	3	15/10/2019 06:31:17	pagex
464646	3	15/10/2019 06:33:29	pagexxxxx
1928764	4	15/10/2019 07:32:15	pagexx

I know there was already a similar post this topic, however the solution provided is just showing where the user starts and where the user ends and does not show the the steps in between.

If someone could help me please.

Thanks in advance

[Anonymous]

Hi @Momo34 ,

Sorry, I did not understand the effect you want. Could you tell me the logic of Number of CustomerID and Path combination?

Also can you explain the logic about the expected chart?

Best Regards,

Stephen Tao

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

[Momo34]

Hi Stephen,

Thanks for your message.

I would like to create a chart that shows me the customer journey of some customers, for example  the different path combinations that some customers had based on their navigation in a website.

Here is the raw data :

Here is what I would like (or something similar) and also if it is possible to calculate the average time between each element of the path :

Thanks in advance

[DHughes]

You might try the PAFNow Process Mining visual.

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000072?tab=Overview

This visual takes audit trail data and creates a map of every journey process variant that happened.  The journey chart looks a little different than what you pictured, but it might provide you with the information you need.

I hope this is helpful

[Greg_Deckler]

@Momo34 

Perhaps you could get the table you want using something like

Table = SUMMARIZE('Table',[Customer],"Path",CONCATENATEX('Table'[Page]))

That looks like a ribbon chart (built in). If that doesn't work:

• You could check for third-party visuals.
• Also, you could check if R visuals might suffice - https://community.powerbi.com/t5/R-Script-Showcase/bd-p/RVisuals
• Also, there are Python visuals. 
• There are also SVG visuals you can create - https://community.powerbi.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=fals... down on that page)
• You could create your own custom visual - https://powerbi.microsoft.com/en-us/developers/custom-visualization/
• Also, https://charts.powerbi.tips/
• Finally, last but not least you could try the Charticulator! - https://charticulator.com/