I am somewhat new to the advanced visualizations in Tableau and am trying to tackle a slightly complicated problem and would appreciate any guidance or help. I have attached the sample workbook that I have created and laid out the problem below. Please let me know if any more information is needed from my end.
Project: I am trying to build a mix of Polygon + Funnel Sankey (https://www.flerlagetwins.com/2019/11/sankey-funnel.html), to map out the consumer flow from one interaction to another
What I have done so far: I have created the sankey flow and have been able to visualize the consumer flow from step0-step6, all my calculations are done in Tableau (see workbook attached).
Problem:
1. Difficulty handling null values in the sankey chart, since the Null values are coming in as 'Null' not blank Tableau assumes that there is data present in that cell rather than no-value, for now I am handling that by showing the drop off rate, but Ideally it should not come in the viz.
2. All sankey flows should stop at O & P and there should not be any lines coming out of (O & P) , but due to missing values there are lines.
Thanks for response.
On every bar chart sheet, exclude 'Drop Off'.
And on path sheet, make changes for some calculations.
Note that you have to repeat creating calculations for each sheet depends on steps.
Then replace [curve] to new [curve (M-N)].
Compute Using of [curve (M-N)] should be [Padded].
<result>
Please find attached workbook. (open with v2020.3 or later)
All calculations are in 'Created by ss' folder.
