Sankey Diagram

Question & Answer
1

I need to understand how users move across different verticals of our company through out their lifetime.

For that, I want to perform an analysis of users orders on business category level to understand how they move across the categories as they order but this is not possible using quicksight only as I’ve learned from AWS official website.

I would like to know in which format should I query data using SQL to create sankey diagram which may help me understand the business better.

Thanks,

2

I have found a solution AWS docs thankfully. Just want to know what is measure in this?

3

Hi @SameedAhmed

It might be helpful if you explain the kind of business problem you want to solve. Can you provide some context?

You can set the measure to whatever you like as long as you have a source and destination field to build the Snakey diagram.