Forum Discussion
Sankey/Flow Diagram Data Structure
Hi Everyone, I am trying to use Sankey diagram for the first time and after several hours of research and experimentation, I still can't figure out how to get the data structure formatted the way it n...
Hi Anonymous
Please check if page 1 in attached file could help.
Regards,
Thanks for your reply v-cherch-msft. I've followed several tutorials but all of them use data structures that are already in formatted to work easily with the Sankey visual. I'm trying to understand how to transform my dataset so that it is optimized for Sankey. I realize now that my formatting didn't show up correctly so below is what my raw dataset looks like that I'd like to understand how to transform for use in the Sankey visual.
| Default Channel Grouping 2.0 Path | Conversions | Conversion Value |
| Channel 2 > Channel 1 | 42 | $14,543.00 |
| Channel 2 > Channel 3 > Channel 1 | 19 | $4,512.00 |
| Channel 5 > Channel 1 | 11 | $74,122.00 |
v-cherch-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous
Please check if page 1 in attached file could help.
Regards,