tag:blogger.com,1999:blog-3178813192704651028.post5055589361388555263..comments2023-12-11T04:18:15.067-05:00Comments on The Flerlage Twins: Analytics, Data Visualization, and Tableau: More Tableau Sankey Templates: Multi-Level, Traceable, Gradient, and More!!Ken Flerlagehttp://www.blogger.com/profile/03698843288892226027noreply@blogger.comBlogger128125tag:blogger.com,1999:blog-3178813192704651028.post-56615252492398032362023-04-20T17:45:07.971-04:002023-04-20T17:45:07.971-04:00Could you send me an email? flerlagekr@gmail.comCould you send me an email? flerlagekr@gmail.comKen Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-43678451576984941252023-04-20T16:22:42.319-04:002023-04-20T16:22:42.319-04:00Dear Ken I tried to check it out several times - n...Dear Ken I tried to check it out several times - nevertheless I'm still lost. Once I remove the green pill [Curve 1-2 Polygon] and try to place it back with exact the same settings it remains red. I thought that if you enter exactly the same settings in the same worksheet it must work just as the original one. What is the root cause for this. Thanx and BR ArnoArnohttps://www.blogger.com/profile/12940761010370951155noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-7249846868220338752023-03-11T22:28:25.474-05:002023-03-11T22:28:25.474-05:00You'd need to check the way the table calculat...You'd need to check the way the table calculation (and all nested table calculations) are computed. Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-25437692333716896702023-03-10T20:54:49.282-05:002023-03-10T20:54:49.282-05:00Dear Tableau Experts, In order to understand the l...Dear Tableau Experts, In order to understand the logic behing the sankey diagrams I experimented a little bit with your artful diagrams. So I have removed the [Curve 1-2 Polygon] variable from the rows and expected when placing it back with the same settings the diagram would not be changed. However it turned out to be different. The diagram was destroyd. Is there a certain seqence that has to be followed when creating the sankey worksheet with [t (Model)], [Curve 1-2 Polygon], [Step 1], [Step 2], etc. Thank you and BR ArnoArnohttps://www.blogger.com/profile/12940761010370951155noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-43975926119700358152023-01-31T18:57:27.329-05:002023-01-31T18:57:27.329-05:00I don't entirely understand. Can you email me?...I don't entirely understand. Can you email me? flerlagekr@gmail.comKen Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-56614628100743667412023-01-31T12:42:11.665-05:002023-01-31T12:42:11.665-05:00This is amazing and so helpful! I've been tryi...This is amazing and so helpful! I've been trying to adapt it to use 2 metrics for the curves (i.e. Size 1= Count of IDs and Size 2 = Sales...and use Size1 for Curve 1-3 and Size 2 for Curve 4-5). Is that possible or have you seen anyone try that? Thank you!Sarah Mnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-47878189995197170302022-12-10T17:11:42.421-05:002022-12-10T17:11:42.421-05:00Ken, this article is still saving lives! Thanks s...Ken, this article is still saving lives! Thanks so much for creating these templates. I have a unique need for a modification of the multi-level Sankey that hopefully, you can assist with. I need to color each of the step levels individually. In the final output, A-D would use a dimension to indicate which color it should be and E-H would use a different dimension to indicate color all the way through the 5th level. When I attempted to replace Bar Color with the dimension onto color everything went bottom-up! Any suggestions on what I'm doing incorrectly are GREATLY appreciated!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-19656234792360828302022-07-23T07:07:55.967-04:002022-07-23T07:07:55.967-04:00Might be best to email me. flerlagekr@gmail.comMight be best to email me. flerlagekr@gmail.comKen Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-11633601867951396122022-07-19T14:40:34.338-04:002022-07-19T14:40:34.338-04:00Can you add a label to the curve, not the bar? I&#...Can you add a label to the curve, not the bar? I've tried and can't seem to do it. We have a request to add a label when part of a curve is clicked on and I've tried by using static x, y coordinates but know I'll need the y to be dynamic. I've tried using one of the midpoint calcs with no luck. Any thoughts? Thanks, Katekpetryhttps://www.blogger.com/profile/13608072083339052612noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-32561114404466919142022-03-16T16:20:08.657-04:002022-03-16T16:20:08.657-04:00Might be easier if you could email me with details...Might be easier if you could email me with details. flerlagekr@gmail.comKen Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-49631784358600789892022-03-16T15:25:06.893-04:002022-03-16T15:25:06.893-04:00is there a way to change the height of bar one? is there a way to change the height of bar one? Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-76864830676488757972022-02-20T20:21:47.045-05:002022-02-20T20:21:47.045-05:00Might be easier if you could email me with details...Might be easier if you could email me with details. flerlagekr@gmail.comKen Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-30112646670391698412022-02-19T16:28:35.751-05:002022-02-19T16:28:35.751-05:00Hi Ken,
I have a question regarding the multi-step...Hi Ken,<br />I have a question regarding the multi-step Sankey. I have an entry in the data where there is a size from step 1 to Step 2, then no other entries in Steps 3-5. Kind of similar to the original Sankey of the engine in your original blog post, here some arrows flow off the diagram and stop.<br />The template handles these by adding a blank entry for Steps 3-5 (for the Null value). Is there a way to remove these from Steps 3 - 5 (where there is a null?).<br /><br />Thanks for this great template and walkthrough.<br /><br />Cheers,<br />BryanBryannoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-89111900287392770962022-01-03T10:52:57.369-05:002022-01-03T10:52:57.369-05:00The calcs in this chart are very very complex and ...The calcs in this chart are very very complex and build upon each other, which was the reason I set out to templatize them (so you can just plug in your data and go). However, if you want a deeper understanding, take a look at the following which is what most of my sankey templates are based upon: https://www.dataplusscience.com/SankeyPolygon.htmlKen Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-30787489753709008122021-12-24T02:29:15.633-05:002021-12-24T02:29:15.633-05:00Hi Ken
Thank you for your post about such a great...Hi Ken<br /><br />Thank you for your post about such a great technique.<br />Could you please publish a video or a blog to explain the calculations you used to create the Bar1, Bar2 and the Curve at the file of "Adjustable Whitespace 2019.1"<br /><br />I am a kind of naive in using Sankey Techniques in Tableau, so I could not catch those calculations.<br /><br />I would appreciate it if you help us with this issue.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-40634229702281680982021-09-23T19:27:02.796-04:002021-09-23T19:27:02.796-04:00I sent an email, let me know if it makes sense. Ba...I sent an email, let me know if it makes sense. Basically trying to understand if it's possible to top drawing the curve after a specific flow reaches last non-null step. In other words, if I use your Five Step Template can I properly draw flows that have less than 5 steps. Thank you.gulohttps://www.blogger.com/profile/10778524942260491213noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-30262449646554083682021-09-22T16:08:54.101-04:002021-09-22T16:08:54.101-04:00I don't quite follow the question. Could you e...I don't quite follow the question. Could you email me with further details? flerlagekr@gmail.comKen Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-40757241514011244412021-09-22T12:49:57.214-04:002021-09-22T12:49:57.214-04:00Hello,
This is great! I am using Multi-level sank...Hello,<br /><br />This is great! I am using Multi-level sankey. I have flows of various length (2-5 steps). It looks like if a row ends for example at step 3, the visual still continues to step 4 and 5 using NULL Step values. Is there a way to end those at the appropriate step? Thanksgulohttps://www.blogger.com/profile/10778524942260491213noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-51638579808574723252021-06-02T09:19:20.326-04:002021-06-02T09:19:20.326-04:00No tutorial, but I'm happy to help if you coul...No tutorial, but I'm happy to help if you could email me. flerlagekr@gmail.comKen Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-77524664713995672022021-06-02T07:36:23.932-04:002021-06-02T07:36:23.932-04:00OK, thanks. I'm still struggling with figuring...OK, thanks. I'm still struggling with figuring out how to get the curves to line up with the bars. They use the same whitespace number, but aren't aligned properly. Is there a step-by-step tutorial anywhere by chance, please? Thanks!Jeff Inglishttps://www.blogger.com/profile/00444452535057001058noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-25650224134427332772021-06-01T14:54:14.434-04:002021-06-01T14:54:14.434-04:00You can just remove Steps 4 and 5 from the spreads...You can just remove Steps 4 and 5 from the spreadsheet then connect to Tableau. All the calculated fields related to those steps will be in error, but you don't need them. You can then just remove the sheets from the dashboard (bar4, bar5, curve 4-5, curve 3-4). If you want, you can also completely delete the sheets and all the bad calculated fields.Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-5406510133868625352021-06-01T13:14:00.796-04:002021-06-01T13:14:00.796-04:00Hi - This is probably overly basic, but I'm st...Hi - This is probably overly basic, but I'm struggling to pare down the aggregate traceable multi-level sankey from the default five steps to just three. Is there a step-by-step tutorial you might be able to point me to, please? Thanks in advance!Jeff Inglishttps://www.blogger.com/profile/00444452535057001058noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-10472015693531089412021-05-23T11:56:15.637-04:002021-05-23T11:56:15.637-04:00Yes you could probably do that, but it'd be tr...Yes you could probably do that, but it'd be tricky to find the right calculation to use as a filter. Happy to help further if you could email me. flerlagekr@gmail.comKen Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-54584340276095954752021-05-21T11:15:16.620-04:002021-05-21T11:15:16.620-04:00Hello Ken,
I have a question for you, would it be ...Hello Ken,<br />I have a question for you, would it be possible to filter by the number of moves between two steps. for example, let's imagine that I am using 4 steps (multi level Sankey) and I want to filter to show only the moves > 6 between step1 and step2 so I can see their flow in the rest of the diagram ( between step2-3 and step 3-4 ). I hope that I made it clear for you. <br />Many thanksAnonymoushttps://www.blogger.com/profile/10803969305301731543noreply@blogger.comtag:blogger.com,1999:blog-3178813192704651028.post-46834447079244069662021-05-12T10:18:12.100-04:002021-05-12T10:18:12.100-04:00You can add any fields you wish to the data.You can add any fields you wish to the data.Ken Flerlagehttps://www.blogger.com/profile/03698843288892226027noreply@blogger.com