Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

visualise multiple relationships between different hierarchy levels

Hi, I've been trying to find a way to visualise a hierarchical data set with multiple links to various levels

 

as a base, this is what I've been working with:

 

base type                        main type    archetype     eats        is eaten by   colour

ColourBrown    
ColourGreen    
ColourOrange ©    
ColourRed    
ColourYellow    
FruitApple  WerewolfGreen
FruitApple   Red
FruitAvocado  WerewolfBrown
FruitBanana  ZombieYellow
FruitCitrusLemon TrollYellow
FruitCitrusLime  Green
FruitCitrusOrange (f)  Orange ©
Supernatural CreaturesTroll Lemon Red
Supernatural CreaturesWerewolf Apple Brown
Supernatural CreaturesWerewolf Avocado Brown
Supernatural CreaturesZombie Banana Green

 

as you can see, the hierarchy goes base type, main type, archetype, eats, is eaten by and colour,

i've tried using force-directed graph which seems to have a nice visual for it, but I cant seem to find any way to visualise interlinked data like this. 

any help would be appreciated.

thanks.

2 Replies

  • Hi Anonymous ,

     

    I'm thinking this could be done using the Sankey visual and the item counts as link weights. However, it's pretty fiddly to set up correctly so not sure if you'd want to go down this route.

     

    Here's a step-by-step guide that I think could help if you wanted to give it a go:

     

    MSSQLTIPS Sankey guide

     

    Another, similar, option may be the Tassells Parallel Sets Slicer visual. This will give you an ouput something like this, which I'm sure could be tidied up a bit:

     

    Pete

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Community Support

    Hi, Anonymous 

    You can search in the App Source to see whether there is a visual that you need.

     

    Best Regards,

    Caiyun Zheng