Forum Discussion

RichardP's avatar
RichardP
Icon for Helper I rankHelper I
8 years ago
Solved

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 cu...
  • v-sihou-msft's avatar
    8 years ago

    RichardP

     

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

     

    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.

     

     

    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,