Adding 3 fields in sankey visualization

Question & Answer
,
1

Hi,

I have 3 fields that are dimensions. How can I show the relation between these 3 fields. I have tried Sankey Diagram but It allows me to add only 2 dimensions and the value but I don’t have value in my dataset.

Could you please help me to show the relationship between these three. I am expecting the visual to be similar to this

image
image1227×640 24.6 KB

My csv looks like:

|Column 1 | Column 2 | Column 3 

|--- | --- | --- | ---|
|Source Table | Target Table | Intermediate Table | 
|db2.table2 | db4.table4 | db1.table1 | 
|db3.table3 | db4.table4 | db1.table1 |

Thank you.

2

Hi @Shariya ,

Welcome to the QuickSight Community!

For this use case, you will need to flatten your data to establish each source to target relationship.

For example, you will need to break row 1 into
db2.tabl2 → db1.table1
db1.table1 → db4.table4
So you will have source to target mapping for all relationships.

And in case you do not have any weightage to add, you can create a dummy value=1 calculated field and add.

Hope this helps!

Thanks,
Prantika

3

Hi,

Thanks for your response. When I tried to visualize my csv it shows db1.table1 on both source and target side where as I want it to be only on one side. I am attaching the diagram for reference. Please assist.
This is how my csv looks like:

|Column 1 | Column 2 | Column 3
|— | — | — | —|
|Source Table | Target Table | Weight | |
|db2.table2 | db2.table2 | 1 |
|db3.table3 | db1.table1 | 1 |
|db1.table1 | db4.table4 | 1 |
|db3.table3 | db4.table4 | 1 |
| | | |

image
image1735×995 58.9 KB

Thanks.

4

Can you change the value for Number of nodes displayed in the Visual settings?

5

Hi,

Thanks for the response.

I have tried adjusting the nodes in visual settings. It shows “other” instead of table name.

image
image1424×647 39.2 KB

6

@Shariya, is this issue resolved? Do you need further assistance? Here is a good discussion: Add multiple parameters to a SanKey diagram

7

Hi @Shariya, did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!