Legacy connections is gone, the first step isn't needed anymore to union tables. Drag the first sheet over, then grab the same sheet again (second one) and drop it ontop the first one to create the union. You'll notice your rows number double, and Tableau will create a column called Table Name on the far right that labels the 2 unions for you ( a '1' is added to the name, you'll see when you scroll down to the bottom half). You won't need to do the Custom SQL now because it does this making the Table Name column. This tutorial worked very will for me, thank you.
Amazing tutorial! I was quite intimidated by the Sankey chart when I firt saw it a few days ago. It looked fascinating but I thought, as a beginner at Tableau, Sankey is way above my level and it would be months before I can actually make one. Even with this tutorial it is a tricky chart to get right. I had to watch this video over and over to get the calculations right. I feel so great now that I have actually made a Sankey chart showing the flow of CO2 from world regions to each year from 1960 to 2011, with actions enabled for regions and years on the Dashboard. I learnt an aweful lot here, thanks to the clean instructions in this tutorial. Sankey is a such a great chart to show so many variables in a single screen.
This is a flipping cracking video, thanks very much. I've managed to get a great looking sankey. Although I don't really understand the maths behind the sigmoid/curve/t calculations, that's more to do with my ignorance of statistics! 10/10
This is a fantastic method to follow. I love this method of visualization and this video was exactly what I needed to add Sankey charts to my arsenal of options. Thank you!
Awesome, thank you Jeremy for your feedback! Check the whole custom chart series when you have time, we put an effort to it, hope you will find our tutorials helpful. Have a nice day!
@@mazenkovski For the first part of the video, since custom SQL connections has been disabled by Tableau and the newer versions do not have this option you can do the following (For tableau desktop public-2022.4): 1. Create duplicate sheets on the excel file (datasource already had sheets duplicated) 2.open the connection excel on tableau 3.drag sheet1 and click on union then drag the other sheet 4.Now you have doubled your data with the last column on the preview showing table_name and cells reflecting which table the data came from sheet1 or sheet2. 5.Create new calculated field in the preview section and use IF ELSE to categorize sheet1 as "Segment" and other sheet as "Region" (Use IF else statement) and name this column as 'Vizside' 6.Now proceed to timestamp 4:39 of the video.
For the first part of the video, since custom SQL connections has been disabled by Tableau and the newer versions do not have this option you can do the following (For tableau desktop public-2022.4): 1. Create duplicate sheets on the excel file (datasource already had sheets duplicated) 2.open the connection excel on tableau 3.drag sheet1 and click on union then drag the other sheet 4.Now you have doubled your data with the last column on the preview showing table_name and cells reflecting which table the data came from sheet1 or sheet2. 5.Create new calculated field in the preview section and use IF ELSE to categorize sheet1 as "Segment" and other sheet as "Region" (Use IF else statement) and name this column as 'Vizside' 6.Now proceed to timestamp 4:39 of the video.
Thanks a lot. It worked for me EVEN I was working with count and percent of total of count. Thanks Thanks. Even sankey extension is of no use in my case . As handling with bigger data, I just adjusted my axis accordingly. But step by step explanation made easier to play around. Thanks a bunch.
what if there's a 3 levels of relationship? for example, Product category level 1 vs level 2 vs level 3. Can still work? Appreciate if record a advanced videos fro this example. :)
Amazing, I just did one as per your instructions (however my case was from segments to segments- different segment categories, and for market potential as opposed to sales) :D
Thanks. But I'm unable to get the same outcome at 7:06 of the video that changes "t" to compute using "Padded". I get only two dots to the left of the axis ranging from -6.2 to zero, rather than 49 dots evenly distributed across the axis ranging from -6.5 to 6.5. Hope you can kindly advise. (I'm using Tableau 10.5.2)
Hi Ji, You need to check whether your ToPad calculated field has been created correctly, and ensure that the Padded bins are then recreated with the size of bin = 1.
Thank you for the tutorial. It well explained. I had some problems using when the segment had a region that was NULL. The color sequence was not working properly. This was resolved when the assigned a value to the region.
Great tutorial! I love the detailed explanation since I have been trying to build a Sankey chart for two days now - in the end I managed, but this video really made me understand a lot of those things that you are otherwise supposed to follow blindly. In this respect, I have a question: what is the rationale behind having to double the dataset? I am not sure I understand that, could you please elaborate a bit?
Doubling it is to setup the LEFT and RIGHT bars of the diagram using the same dataset. Essentially, looking at co-relation of Segment vs Region within that single dataset.
I am using Tableau 2021.3 version without legacy connection , My data values are doubled because I joined two excel files together to make sankey. How can I rectify that. Look forward to your speedy reply
Hey AoV thanks for the tutorial, just want to know if not do a UNION ALL in custom query, would that be valid to do the dashboard actions on highlighting, especially from right to the left, as mine was not include a custom union all, and can only highlight the dashboard from left to right.
Hi, Im trying to this this exact same diagram but I also need to compare the data through time. So I do have numbers (years) and they act like the "1, 2, 3, ...,49". I have the viz already, it's about renewable energy on 15 countries and its transition through time. BUT my problem is that the 3 lines of type or enegry start from each country but they end radomly not in 3 groups! Can someone help me? I used years as "padded"
Does anyone know if there is a way to sort the curve portion of the graph by a value (say percentage decreasing?) I'm able to sort my bar chart on the right but the sankey lines no longer match when I do this.
I am trying to do the Sankey chart but having horizontal bars on both the left and right sides, instead of stacked bar charts. What do I have to do to get that working?
The challenge is that the data for the three columns I want to use comes from different tables, and they are connected through data blending. how to proceed. Do you have any ideas how to perform union in this 3 tables or any other method instead of union?
Tableau no longer supports Legacy Connections, "Starting in Tableau 2019.1, you will no longer be able to create a new Legacy Excel or Text connection. Existing workbooks created with these legacy connections will continue to work until 2019.2, when all support for legacy connections will be removed." Do you know of a workaround for this?
I used excel to manually paste the data under the already existing data, and added the Viz column manually as well. Took me 2 minutes to do this. The other workaround is to download Tableau build prep, but I found the excel method way easier.
Hey, i am using newer version of tableau so i just created a Union and then new column named Table name was created but there were values of SalesData in column instead of Segment and region. Can anyone help me with this please. Thanks
hey, try this method in the calculated field for ToPad If [Table Name]= 'SalesData' then 1 else 49 END This worked fine for me because this was the generated count value tableau created when you create the union.
Hi, can you please explain why the union is necessary. The concern I have is bloating the data model. Could you have not used just the segment and the region columns from the original dataset?
This is brilliant. I wonder if there is anyway to allow the lines to be gradient as they go across the t x axis. It would probably be too trippy to look at unless you had a small amount of left and right side variables.
Did it! It is wild, but by putting the t pill on columns twice and then making the first x axis be -5 to 0 and the second be 0 to 5, and then editing the t and t(2) mark cards instead of the All cards, I've got myself a very wild sankey.
10/10 for creativity, but this is SOOO complex! Obviously Tableau wasn't meant to do vizzes like this. It's more like one giant workaround to trick Tableau into do this!
This is not the simplest task we agree. And you can do this with different software without these complicated steps. But one of the most important strengthens of Tableau is interactivity. If you want interactive dashboard with Sankey diagram, it would be easier to do with Tableau even with this workaround.
I couldn't get the "open with Legacy Connection" option when opening the file - using Tableau Public 10.5.0 on Mac OS Sierra10.12.3 . Is there a workaround for this? i don't get "convert to SQL" option ... Any tips would be very much appreciated! :) Thank you!
Cool video, and i hv taken ur class on udemy. What i think would be an awesome class to develop is a how do u do this class. Example: how do u create a header. Simple right not really - u hv to create a calculated field. Most ppl would call it tips and tricks. The problem with tableau everything is a tip and trip. If u fully understand the basics other other stuff wrks itself out
It is a great example. I have some issue in this. I want to create the same segments for the left and right dimension. I created a sankey diagram and they are mis-positioned between diagram and dimensions on left and right. You help would be greatly appreciated. thanks
Hi. I am new to tableau, I would like to use for cretinf a sankey diagram for my thesis. And there is this problem I have. When I drag ToPad to the columns it becomes automatically SUM(ToPad) how could I change as it is displayed in the video ?
Union needs to be the same data type too :), header has to be spelled the exact same, same order per selectstatement. great work, this is very helpful.
This was a fantastic tutorial. I do have a question though. The data I want to plot is categorical (I want to visualize changes in major over a semester) so I only have counts of majors at the beginning and end, not a continuous variable like you use here (sales). I've got the chart all set up, relatively well by using the COUNT function instead of SUM function, but there is an alignment issue between the curves and the bar chart. So the people in Major A on the curve dip below the representative percentage on the bar chart. Any idea how I can modify for it to work?
Hi Laxgrl2787, quite difficult to tell without seeing all of the data and what you have done. What I would suggest, is to ensure that you use the correct function (COUNT) throughout your model.
I had the same problem. It turns out if you are using the latest version of Tableau (2019.1), you can no longer import data as a legacy file, which means custom SQL is not available. That said, you can do a Union by dragging the data sheet into the canvass a second time. When you do that, a new field appears in the table showing the table names SalesData and Sales Data1. I renamed that new field VizSide and was able to complete the remainder of the tutorial. Hope that helps and best of luck!
@Art of Visualization Great manual, thanks! I have a question - if i want to sort this groups on the left and on the right side of sankey by descending what should i do with the sankey?
I have a windows 10 OS and Tableau Public 10.4 64 Bit version. After importing the excel file with the legacy connection option, the cconvert to SQL button doesnt exist. Whats the problem, can you please help me with this? :)
Great tutorial. I have built the chart but I need to show the actual value of measure (in this case sales) in the Sankey chart tooltip. When I add the simple measure (no calculation), it is showing blank. Could you elaborate how to do this please?
Hi There! Thanks for this amazing work! Is there a tutorial for how to make a multi-step sankey somewhere? Your video is amazing and the easiest way I have found to reduplicate with all my data. Basically, I would need a third section, like county as a third addition to region and segment. Any way I might go about this or anyplace you would recommend? I sent you an email as well! Thanks so much!
Simply brilliant! we need creators like you who are to the point! Simple and clear
Legacy connections is gone, the first step isn't needed anymore to union tables. Drag the first sheet over, then grab the same sheet again (second one) and drop it ontop the first one to create the union. You'll notice your rows number double, and Tableau will create a column called Table Name on the far right that labels the 2 unions for you ( a '1' is added to the name, you'll see when you scroll down to the bottom half). You won't need to do the Custom SQL now because it does this making the Table Name column. This tutorial worked very will for me, thank you.
Hey, i tried to do the same. But in Table name there were values of SalesData instead of segment. Could you tell me how to correct it ?
thank you for the comment, it saved my lot of time
this was the problem i tried to troubleshoot, but somehow I am too dumb for it ;( can anyone help out?
this worked perfectly for me, thank you!
During ToPad calculation, how should we write according to new "Table Name 1"?
Amazing tutorial! I was quite intimidated by the Sankey chart when I firt saw it a few days ago. It looked fascinating but I thought, as a beginner at Tableau, Sankey is way above my level and it would be months before I can actually make one. Even with this tutorial it is a tricky chart to get right. I had to watch this video over and over to get the calculations right. I feel so great now that I have actually made a Sankey chart showing the flow of CO2 from world regions to each year from 1960 to 2011, with actions enabled for regions and years on the Dashboard. I learnt an aweful lot here, thanks to the clean instructions in this tutorial. Sankey is a such a great chart to show so many variables in a single screen.
Can't thank you enough for this one. Great example. Good pace. Perfect level of detail (no pun intended). Brilliant.
Incredible work! I always wondered how to make visualizations like these and this video came from heaven itself!
Thanks for your comment, Luis! Enjoy the content and please let us know if you would like to see any particular topics on our channel
Great Tutorial. Thanks for this awesome explaining of the Sankay Diagram in tableau.
Amazing, thank you for this tutorial. Very helpful
You explained that so clearly. Had mines working by the time the video ended thanks!!!
Great Tutorial. thanks for explaining this and trying to explain the calculated fields in a user friendly way.
Great tutorial - clear, easy to follow, and even explaining why it works - nice work!
Hi Stephen,
Thanks for your feedback!
This is a flipping cracking video, thanks very much. I've managed to get a great looking sankey.
Although I don't really understand the maths behind the sigmoid/curve/t calculations, that's more to do with my ignorance of statistics! 10/10
Thanks for your fantastic feedback Scott!
Appreciate it
This is a fantastic method to follow. I love this method of visualization and this video was exactly what I needed to add Sankey charts to my arsenal of options. Thank you!
Awesome, thank you Jeremy for your feedback!
Check the whole custom chart series when you have time, we put an effort to it, hope you will find our tutorials helpful. Have a nice day!
Thank you for this wonderful video on Sankey chart!
Extremely cool. Thanks for making this method so accessible.
You are most welcome Jimmy!
it is a great video to learn quickly sankey chart. awesome...amazing....
wow thanks for this video! very useful for my internship
Tutorial very well done. BRAVO and thank you ! The visual effect is powerful
Will applied this. Going to add this sankey diagram to one of my favourite chart. Thx for the tutorial
You are most welcome Mia!
Fantastic tutorial. Very helpful.
Wow Andy!
Thanks for your comment :)
Please to hear it from a Tableau Master
How do you convert to custom mySQL (2:29) now at 2022???? (this video is from 2017)
Did you find out how to do it?
@@mazenkovski For the first part of the video, since custom SQL connections has been disabled by Tableau and the newer versions do not have this option you can do the following (For tableau desktop public-2022.4):
1. Create duplicate sheets on the excel file (datasource already had sheets duplicated)
2.open the connection excel on tableau
3.drag sheet1 and click on union then drag the other sheet
4.Now you have doubled your data with the last column on the preview showing table_name and cells reflecting which table the data came from sheet1 or sheet2.
5.Create new calculated field in the preview section and use IF ELSE to categorize sheet1 as "Segment" and other sheet as "Region" (Use IF else statement) and name this column as 'Vizside'
6.Now proceed to timestamp 4:39 of the video.
For the first part of the video, since custom SQL connections has been disabled by Tableau and the newer versions do not have this option you can do the following (For tableau desktop public-2022.4):
1. Create duplicate sheets on the excel file (datasource already had sheets duplicated)
2.open the connection excel on tableau
3.drag sheet1 and click on union then drag the other sheet
4.Now you have doubled your data with the last column on the preview showing table_name and cells reflecting which table the data came from sheet1 or sheet2.
5.Create new calculated field in the preview section and use IF ELSE to categorize sheet1 as "Segment" and other sheet as "Region" (Use IF else statement) and name this column as 'Vizside'
6.Now proceed to timestamp 4:39 of the video.
Well done Sir! We will use your very technique to display data flows in an Asset Intelligence Center
Hi Holger,
Good luck to you!
Thanks a lot. It worked for me EVEN I was working with count and percent of total of count. Thanks Thanks. Even sankey extension is of no use in my case . As handling with bigger data, I just adjusted my axis accordingly. But step by step explanation made easier to play around. Thanks a bunch.
Awesome -- exactly how tutorials should be done! Thanks so much!!
Thanks for your feedback Hipster! :D
love the tutorial... Bless you!
That's great. I first time see the Sankey chart was through R but didn't realize Tableau can achieve that. I will try it later on.
Awesome, good luck to you!
what if there's a 3 levels of relationship? for example, Product category level 1 vs level 2 vs level 3. Can still work? Appreciate if record a advanced videos fro this example. :)
Hi Jason,
Yes, this is doable.
Thank you for your suggestion, we will think about more advanced way.
that's amazing your Tableau skills
Great tutorial. I have just started learning Tableau and I hope I will reach this point. Thanks a lot.
Thank you Mubashirulislam for your comment. Indeed, the topic is not the easiest. But with help of our courses, soon you will be able to make it.
very well explained and very helpful. Thank you.
This, is absolutely superb. Thank you very much. Simply outstanding.
Great work! Thank you very much!
You are most welcome Ozan!
Super helpful tutorial! Followed step by step and it gave me the chart I needed. Thank you! :)
Thank you for your comment Mengqiao!
Great detail simple. This is a great way to learn will refer
could you make a sales forecast?
Amazing! It was so helpful ... thanks for preparing and sharing the lesson.
This is so helpful! Thank you!!
As I was looking for this chart. I could create it on Adobe Analytics, but was trying to figure out how to do it on Tableau. Thank you!
Thank you very much for all the help.
It's a great tutorial.
Regards.
Hi Miguel,
We are happy to help you!
Really well done! Thank you for making this.
Great explanation it is good to learn how to do it.
Are most welcome Jean))))
Thank you soo much! I was able to do it easily!
Amazing tutorial, really well explained step by step! Thank you :)
You are most welcome Melissa!
Amazing, I just did one as per your instructions (however my case was from segments to segments- different segment categories, and for market potential as opposed to sales) :D
Glad to know that it helped you out!
Thanks. But I'm unable to get the same outcome at 7:06 of the video that changes "t" to compute using "Padded". I get only two dots to the left of the axis ranging from -6.2 to zero, rather than 49 dots evenly distributed across the axis ranging from -6.5 to 6.5. Hope you can kindly advise. (I'm using Tableau 10.5.2)
Hi Ji, You need to check whether your ToPad calculated field has been created correctly, and ensure that the Padded bins are then recreated with the size of bin = 1.
Thank you for making such a helpful tutorial!
Thank you. It was really helpful :)
Thank you for the tutorial. It well explained. I had some problems using when the segment had a region that was NULL. The color sequence was not working properly. This was resolved when the assigned a value to the region.
Very Well explained , comprenshive.
Thank for tuning in Archit
Amazing, great video!
Thank you, Harun for your comment!
THANK YOU FOR THE GUIDE
Glad you found the guide helpful!
Muy bueno el Tutorial, Mil gracias!! me ayudo mucho y me enseño...
Eres bienvenido Camilo!
Great tutorial! I love the detailed explanation since I have been trying to build a Sankey chart for two days now - in the end I managed, but this video really made me understand a lot of those things that you are otherwise supposed to follow blindly.
In this respect, I have a question: what is the rationale behind having to double the dataset? I am not sure I understand that, could you please elaborate a bit?
Doubling it is to setup the LEFT and RIGHT bars of the diagram using the same dataset. Essentially, looking at co-relation of Segment vs Region within that single dataset.
Amazing video, thanks.
Amazing tutorial, thanks so much :)
How do I add the column Vizside in Tableau Public Desktop since I am using the latest version of Tableau in 2024 and custom SQL is no longer an option
I am using Tableau 2021.3 version without legacy connection ,
My data values are doubled because I joined two excel files together to make sankey. How can I rectify that. Look forward to your speedy reply
Hey AoV thanks for the tutorial, just want to know if not do a UNION ALL in custom query, would that be valid to do the dashboard actions on highlighting, especially from right to the left, as mine was not include a custom union all, and can only highlight the dashboard from left to right.
Hi, Im trying to this this exact same diagram but I also need to compare the data through time. So I do have numbers (years) and they act like the "1, 2, 3, ...,49". I have the viz already, it's about renewable energy on 15 countries and its transition through time. BUT my problem is that the 3 lines of type or enegry start from each country but they end radomly not in 3 groups! Can someone help me? I used years as "padded"
Any reason why we had to do Union the data, can we not achieve this without Union?
Does anyone know if there is a way to sort the curve portion of the graph by a value (say percentage decreasing?) I'm able to sort my bar chart on the right but the sankey lines no longer match when I do this.
I am trying to do the Sankey chart but having horizontal bars on both the left and right sides, instead of stacked bar charts. What do I have to do to get that working?
The challenge is that the data for the three columns I want to use comes from different tables, and they are connected through data blending. how to proceed. Do you have any ideas how to perform union in this 3 tables or any other method instead of union?
Thanks a lot for excellent tutorial
You are most welcome, keep tuning in! :)
Thank you. This helped a lot.
This helped a lot.. I am trying to make something like segment to region (most sales ) and to region (2nd most sales)
Hope you will succeed Meera! :)
Brillaint but so complicated !
Tableau no longer supports Legacy Connections, "Starting in Tableau 2019.1, you will no longer be able to create a new Legacy Excel or Text connection. Existing workbooks created with these legacy connections will continue to work until 2019.2, when all support for legacy connections will be removed." Do you know of a workaround for this?
We will check this out. Thanks for your notice.
Just duplicate the data with a cartesian join
Thanks! I spend 15 minutes looking for this option before I googled it! I should have read your comment first :)
PLEASE DO :( ! I use this set-up far too often now to just have it removed without a back-up option …..
I used excel to manually paste the data under the already existing data, and added the Viz column manually as well. Took me 2 minutes to do this. The other workaround is to download Tableau build prep, but I found the excel method way easier.
Hey, i am using newer version of tableau so i just created a Union and then new column named Table name was created but there were values of SalesData in column instead of Segment and region. Can anyone help me with this please.
Thanks
hey, try this method in the calculated field for ToPad
If [Table Name]= 'SalesData' then 1 else 49
END
This worked fine for me because this was the generated count value tableau created when you create the union.
Hi, can you please explain why the union is necessary. The concern I have is bloating the data model. Could you have not used just the segment and the region columns from the original dataset?
It was great tutorial. Thanks alot!
hi ,
is it possible yet to give a link to the dataset ?
This is brilliant.
I wonder if there is anyway to allow the lines to be gradient as they go across the t x axis. It would probably be too trippy to look at unless you had a small amount of left and right side variables.
Did it! It is wild, but by putting the t pill on columns twice and then making the first x axis be -5 to 0 and the second be 0 to 5, and then editing the t and t(2) mark cards instead of the All cards, I've got myself a very wild sankey.
Really? Could you please share a screenshot?
Can I do this in Tableau public?
10/10 for creativity, but this is SOOO complex!
Obviously Tableau wasn't meant to do vizzes like this. It's more like one giant workaround to trick Tableau into do this!
This is not the simplest task we agree. And you can do this with different software without these complicated steps. But one of the most important strengthens of Tableau is interactivity. If you want interactive dashboard with Sankey diagram, it would be easier to do with Tableau even with this workaround.
I couldn't get the "open with Legacy Connection" option when opening the file - using Tableau Public 10.5.0 on Mac OS Sierra10.12.3 . Is there a workaround for this? i don't get "convert to SQL" option ... Any tips would be very much appreciated! :) Thank you!
Hi Anna, check please previous comments. Workaround explained to chinez11.
I did EXACTLY how the video suggested to do and even the ToPad calculation is not there. What can be the problem?
why the lines never become the same size (thickness) as the example was shown?
Could you please give us the link for dataset
Cool video, and i hv taken ur class on udemy. What i think would be an awesome class to develop is a how do u do this class.
Example: how do u create a header. Simple right not really - u hv to create a calculated field. Most ppl would call it tips and tricks. The problem with tableau everything is a tip and trip. If u fully understand the basics other other stuff wrks itself out
Thanks for your suggestion Joe!
We will definitely consider it!
You are a god!
It is a great example. I have some issue in this.
I want to create the same segments for the left and right dimension.
I created a sankey diagram and they are mis-positioned between diagram and dimensions on left and right.
You help would be greatly appreciated.
thanks
Hi Aung. You need to ensure that the order in which the data is accessed is the same for Sankey chart as well as the left and right dimensions.
Ugh, thank you, I've been trying to find the name for these 😆
Hello, I just find you're video but iIm french so I don't understand all you're video but thanks you for this Video
Hi. I am new to tableau, I would like to use for cretinf a sankey diagram for my thesis. And there is this problem I have. When I drag ToPad to the columns it becomes automatically SUM(ToPad) how could I change as it is displayed in the video ?
I write the exactly the same thing as in the video "if [VizSide] = "Segment" then 1 else 49 end " and it doesnt seem to creta the value 1 ...
Hi, did you use exact syntax?
Could you please add a screenshot of your formula?
halo sir thanks for your effort I am not able to open file with legacy can you help out
I didi this but used an aws athena table, still worked great! just had to use custom sql to union them :)
Union needs to be the same data type too :), header has to be spelled the exact same, same order per selectstatement.
great work, this is very helpful.
Nice! Thx you so much
Great tutorial. I learnt a lot .Can you also make a tutorial video for Marimekko chart please? Thanks
Sure, I will ask instructors to prepare this tutorial.
Thank you for your suggestion Thao!
This was a fantastic tutorial. I do have a question though. The data I want to plot is categorical (I want to visualize changes in major over a semester) so I only have counts of majors at the beginning and end, not a continuous variable like you use here (sales). I've got the chart all set up, relatively well by using the COUNT function instead of SUM function, but there is an alignment issue between the curves and the bar chart. So the people in Major A on the curve dip below the representative percentage on the bar chart. Any idea how I can modify for it to work?
Hi Laxgrl2787, quite difficult to tell without seeing all of the data and what you have done. What I would suggest, is to ensure that you use the correct function (COUNT) throughout your model.
Whoever came out with this solution is a fking einstein
i'm unable to select convert to customer SQL. it doesn't appear on the data menu, even after I drag the table
I had the same problem. It turns out if you are using the latest version of Tableau (2019.1), you can no longer import data as a legacy file, which means custom SQL is not available. That said, you can do a Union by dragging the data sheet into the canvass a second time. When you do that, a new field appears in the table showing the table names SalesData and Sales Data1. I renamed that new field VizSide and was able to complete the remainder of the tutorial. Hope that helps and best of luck!
@@USABearOnTheAir Hey, I'm a new here, so could you please clarify a bit? What kind of join should we use? What field did you rename? "SalesData1"?
any video regrading multi level sankey
Can you please share dataset as well
@Art of Visualization Great manual, thanks! I have a question - if i want to sort this groups on the left and on the right side of sankey by descending what should i do with the sankey?
I have a windows 10 OS and Tableau Public 10.4 64 Bit version. After importing the excel file with the legacy connection option, the cconvert to SQL button doesnt exist. Whats the problem, can you please help me with this? :)
Hi Nirvan,
Could you please try this - kb.tableau.com/articles/howto/editing-custom-sql
Can you please share any ideas on how to create a speedometer chart?
Hi Mola, check our series, we shared some techniques.
Clockface duration chart uses same techniques
This is badass thank u
Beatiful, thank you!!
You are most welcome Gengar!
Great tutorial. I have built the chart but I need to show the actual value of measure (in this case sales) in the Sankey chart tooltip. When I add the simple measure (no calculation), it is showing blank. Could you elaborate how to do this please?
Hi There! Thanks for this amazing work! Is there a tutorial for how to make a multi-step sankey somewhere? Your video is amazing and the easiest way I have found to reduplicate with all my data. Basically, I would need a third section, like county as a third addition to region and segment. Any way I might go about this or anyplace you would recommend? I sent you an email as well! Thanks so much!
I'm interested in this also. Apparently there are third party extensions for purchase, but I would like to be able to do it on my own.
Anyone know how calculate the percent of total by each line? Thanks.