Hi all,
I am building a sankey chart to show the flow of transactions.
Ideally I would like to use the Sankey Path visualisation.
My data is structured with column names:
from, from_type, to, to_type, value
There are 4 stages to the flow. I would like to be able to filter the visualisation to show the flow for certain types of transactions across 4 stages of the sankey path chart.
- Inflow
- Classification
- Clearing
- Root Cause
from_type can = Inflow, Classification and Clearing
to_type can = Classification, Clearing and Root Cause
I was hoping to make the visualisation filter the value in the sankey flow based on the selections in the 'from' list.
It doesn't. The sankey continues the flow with the filtered out values.
Here, I have filtered on "Price Differences" in the from list and also on "Valid" and "Invalid".
However, I would like the sankey to only show values in the rest of the flow that originate with "Price Differences". As you can see, it seems to consider the values from the other "inflow" category
I appreciate this is messy and I have probably not articulated the problem too well (I've done my best) so if there are any kind souls out there who can help, I would be very grateful.
