cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RichardP Regular Visitor
Regular Visitor

Sankey diagram - data structure question

Hi,

 

I'm attempting to see if I can use the Sankey visual to illustrate the main user journeys through a website.  However I'm not sure what format I need the data in to make this work.

 

The current format of the data is:

 

USER IDDATETIMEWEBSITE SECTIONPOSITION IN JOUNREY
11120/10/2017 09:18:21Home1
11120/10/2017 09:18:30Search Results2
11120/10/2017 09:19:00Article Page3
11120/10/2017 09:19:58Article Page4
11101/11/2017 17:19:58Article Page1
11101/11/2017 17:22:58Home Page2
11101/11/2017 17:23:25Article Page3
22207/10/2017 12:14:25Home Page1
22207/10/2017 12:15:10Search Results2
33324/10/2017 15:15:10Home Page1
33324/10/2017 15:15:25Article Page2
33324/10/2017 15:16:01Home Page3

 

The "Position in Journey" column identifies that it was the first, second, etc page to be visited during a visit.

 

A given user may make multiple visits to the website.

 

A successful outcome for me would be to show the pages in 'Position 1', with the flows on to the pages in 'Position 2', etc.

 

If there are better ways than a Sankey visualisation to achieve this, I'm happy to learn! Smiley Happy

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Moderator v-sihou-msft
Moderator

Re: Sankey diagram - data structure question

@RichardP

 

To use Sankey chart, you dataset should have columns like Source, Target, Weight column. It can be like: 

 

23.PNG

It means on row level, you need to have current Position and next Postion info, with some weight. So in your scenario, you need to put Positions into Source and Target. It can be like: 

 

 

Source                 Target 

Home                  Search Results

Search Results        Article Page

Article Page         Article Page

However, this visual currently can't analyze on some other data field level.

 

55.PNG

 

As I notice that you also have UserID and DateTime columns in your table, you may create one slicer for User, one slicer for DateTime. 

 

Currently I haven't seen any other published custom visual better on showing flow diagram. 

 

Regards,

1 REPLY 1
Highlighted
Moderator v-sihou-msft
Moderator

Re: Sankey diagram - data structure question

@RichardP

 

To use Sankey chart, you dataset should have columns like Source, Target, Weight column. It can be like: 

 

23.PNG

It means on row level, you need to have current Position and next Postion info, with some weight. So in your scenario, you need to put Positions into Source and Target. It can be like: 

 

 

Source                 Target 

Home                  Search Results

Search Results        Article Page

Article Page         Article Page

However, this visual currently can't analyze on some other data field level.

 

55.PNG

 

As I notice that you also have UserID and DateTime columns in your table, you may create one slicer for User, one slicer for DateTime. 

 

Currently I haven't seen any other published custom visual better on showing flow diagram. 

 

Regards,