Forum Discussion
Visualizing customer journey through a chart (different paths)
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
4 Replies
Anonymous
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=false&filter=location&location=forum-board:QuickMeasuresGallery&q=svg (scroll 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/
Hi Anonymous ,
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.
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
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
