I am playing around with this new visualization and am wondering if I can use it in the following situation:
I have a table that has a state code and an office code. I would like to see the Sankey from state to office. I have tried the simple approach but it doesn't show a graph.
I use the state and office as source and target respectively with the count of the record keys as the measure.
Any guidance or hint is appreciated.
The docs example contains an CSV table. A many to many mapping exists in this data, meaning a source can be a target and a target can be a source. Morocco is both a Country_Target and a Country_Source. Hope that helps!
Country_Source, Country_Target, Resources Brazil, Portugal, 5 Brazil, Spain, 1 Canada, Portugal, 1 Mexico, Portugal, 1 Mexico, Spain, 5 Portugal, Egypt, 2 Portugal, Senegal, 1 Portugal, Morocco, 1 Spain, Senegal, 1 Spain, Morocco, 3 Egypt, China, 5 Egypt, India, 1 Egypt, Japan, 3 Senegal, China, 5 Senegal, Japan, 3 Morocco, China, 5 Morocco, India, 1 Morocco, Japan, 3