I'm working on trying to make a data table to faci...
# gooddata-cloudr
Ryan Peters
06/05/2025, 6:36 PMI'm working on trying to make a data table to facilitate the Sankey chart. Not sure where I'm going wrong. Details in thread
Ryan Peters
06/05/2025, 6:36 PMimage.png
Ryan Peters
06/05/2025, 6:36 PMimage.png
Ryan Peters
06/05/2025, 6:36 PMTabular results from that table.
Ryan Peters
06/05/2025, 6:37 PMI'm trying to figure out:
• How does my data need to shift compare to what it is here
• How do I organize an order to the field value(s) in the From space
• How would I integrate additional filters (users, tenants, dates et al)
m
Mauricio Cabezas
06/05/2025, 7:14 PMHi Ryan, thank you for this, Im happy to help.
At first glance I would say there is no 'error'. But looking into the values of the metric it appears the rendering issues are likely due to the wide range of values in your metric, like the value '20786' you might have observed alongside smaller values. This can make the chart visually compressed and hard to interpret. Our primary recommendation is to try filtering out these 'outlier' values to see if that improves the visualization. Can you try as a test, to filter out the 'Exit Sidd' value?
Regarding your questions:
1. Could you please clarify what you mean by "shift" here?
2. Currently, Sankey charts do not support direct sorting of nodes (field values) within the Analytical Designer (as per our documentation here: https://www.gooddata.com/docs/cloud/create-visualizations/sort-data-in-insights/).
3. If I understand correctly, for users and tenants you can check using Workspace Data Filter (WDF) or User data filter (UDF). And, for dates or attributes, there is the option for dashboard level filter and Insight/attribute filter.
If the answers does not help, please feel free to clarify them.
r
Ryan Peters
06/05/2025, 7:25 PMJust testing on it:
If I filter out exit sidd, I get way less values, and I still get this weird visualization approach
Ryan Peters
06/05/2025, 7:25 PMimage.png
Ryan Peters
06/05/2025, 7:25 PMSo not sure why it's not giving a full proper sankey diagram.
m
Mauricio Cabezas
06/05/2025, 7:43 PMThank you for this, would you be so kind to share the ID of insight to investigate further? or direct link, feel free to use DM. We will keep you posted with an update.
Mauricio Cabezas
06/06/2025, 1:29 PMHi Ryan,
Thank you for your time. We've impersonated your organization and thoroughly investigated the insight and underlying data for your Sankey chart.
First, we want to reiterate a core limitation of Sankey charts: they cannot properly display circular or backward flows (e.g., if a flow goes A → B and then later B → A, or a flow directly back to itself). If such cycles are present in your data, the Sankey chart won't render correctly, as outlined in our documentation: https://www.gooddata.com/docs/cloud/create-visualizations/visualization-types/sankey-diagrams/.
During our impersonation, we observed that many of your attributes are present in both the 'From' and 'To' fields. While flows like 'Item Availability (From)' → 'Reorder Workflow (To/From)' → 'Exit Sidd (To)' can generally render, we've identified a specific problematic flow involving 'Lost Order' and 'Master':
'Lost Order (From)' → 'Master (To/From)' → 'Lost Order (To/From)' → 'Master (To/From)' and so on, This specific pattern creates the circular flow that the Sankey chart cannot handle, directly causing the rendering issues you're experiencing.
Filtering out 'Lost Order' (from either the 'From', 'To', or both attributes) allows the chart to render because it breaks this particular problematic cycle. For future reference, it's essential to check if other parts of your data also create such cycles, as they could lead to similar rendering anomalies.
For visualizing relationships that inherently contain circular or bidirectional flows, we highly recommend exploring the Dependency Wheel Chart. It is specifically designed for these more complex network flows that Sankey diagrams cannot accurately represent.
You can find more details on the Dependency Wheel Chart here: https://www.gooddata.com/docs/cloud/create-visualizations/visualization-types/dependency-wheels/
Please let us know if you have any further questions.
r
Ryan Peters
06/09/2025, 6:29 PMI think I figured most of it out; Only one problem that frustrates me.
The Lost Order -> Exit Product sector overlaps everything. Is there any way to ensure the flows don't overlap? What's the method to do that or is it available?
m
Mauricio Cabezas
06/12/2025, 11:08 AMHi Ryan, thank you for your patience and my apologies for this delay. I am aware of this message I have asked to our engineers but still I do not have answer. I will keep you updated.