Can you share how it would be possible to sort the categories not by Rank (of sales) but instead a manual sort - ie I can choose if furniture is at the top regardless of sales? Thanks for your help
Thats a great question. You could use the custom sort on the dimension value rather than sales. Please try and let me know incase you need more info.. Cheers!
Thanks for y our feedback. Yes, its hard to remember all steps but you can refer to this tutorial when you are building this chart. With practice you will be able to do that.
Awesome video! Just wondering how to sort by category in a specific order (pipeline) vs by total sales by category. I can't seem to do it with custom sorting.
You can do that by sorting in tableau calculation in a particular order. You can also do that by bringing calculated field in the table calculation. Please try that and let me know incase of any issue.
You could use a filter. Example: Use Categories in the filter shelf. Then edit the filter and you will see 4 tabs in the pop up window i.e. General, Wildcard, Condition & Top Select the Top one Then select the radio button for "By Field" Then select top 10 (Or. what ever is your requirement) Then select "sales" measure and aggregation of "Sum" then click ok All done :-) do this in all the levels to achieve desired result
Hi , In this chart we are using data densification techinque to artificially create points. for that we have used "path" field with two values . In between these two values we are artificially creating points using bin. So each row gets duplicated when we join it with Path. Thats why the Sales number gets doubled. Inorder to avoid that , we divided it by 2. Hope that helps 🙂 Please feel free to reach out if you need more information.
What if I want to display only the top 10 sub-categories in the dendrogram based on the sales values, only top 10, not all of sub categories? How can I do it?
You could use a filter. Example: Use Categories in the filter shelf. Then edit the filter and you will see 4 tabs in the pop up window i.e. General, Wildcard, Condition & Top Select the Top one Then select the radio button for "By Field" Then select top 10 (Or. what ever is your requirement) Then select "sales" measure and aggregation of "Sum" then click ok All done :-) do this in all the levels to achieve desired result
There is an another way using calculated field and parameter. Check out below blog post from Flerage brothers www.flerlagetwins.com/2019/05/intro-to-data-densification.html Hope that helps
great video, one question though, should we use a new calculation field of sales/2 for sheet 2 and 3 since I thought the numbers are duplicated when we were using the original sales field, thanks
Yes you are correct. That seems to be an error in the video. Due to data densification, we need to divide sales by 2 . Thanks for pointing that out :-)
cargouvu : Yes we can create this chart with multiple layers with few additional calculations. Will share the tutorial on that soon. Please stay tuned 😊
Hello, I just had to visit my high school math ;) No other resource apart from my tutorial. Please let me know which part you didnt understand and i will try to provide more details.
While doing an exercise for creating this chart, I found the below error under Y Axis Table Calculation "COUNT is being called with (numerical bin), did you mean (table)? "
Hi Zabiyoddin, Y axis table calculation is computed using specific calculation of Sub Category. You could download the dashboard from tables public using below link
@@DataVizCanvas On the Table Calculation step of @Y I also got the same error: "An error occurred while communicating with data source 'Sample - Superstore' Error Code: 19841555 COUNT is being called with (numerical bin), did you mean (table)?" When I checked the comments after getting this error, I saw that I was not alone in this error :). When I download your workbook, it looks fine, but do you have any idea why we might have encountered this error at this step? Version difference? btw Thanks a billion for your magic!
@@MehmetSezer7 This issue was caused due to the use of "bin" with data relationship. Upgrading to tableau desktop to 2021.2 or more will solve this. Alternatively please use data join instead of data relationship. Hope that helps. Cheers! Gurpreet
Hi Joneesh, Please copy the data in excel file and use that as data source rather than paste as clipboard. Please try that and feel free to reach out in case of any issues 😊
Hi Sandeep, please try watching tutorial in below playlist where I have shared different ways of drill down at multiple level using dendrogram chart ruclips.net/p/PLMbGQrGl-0EuBew3uS85ZitX_Evc8oJp2
any idea of how to adjust the display when applying filters? even using containers, the dendrogran lines don't appear centralized as the sub-total is.. and great job on the video my dear!!
Hi Gustavo, Do you mean that the alignment of the dendrogram lines doesn't align with the total sales value. In that case you can use custom alignment in text mark and make adjustments there for both sheets. Please feel free to reach out if you need more info and would appreciate if you can share your dashboard link as it will help to investigate your issues. Cheers!
Yes, sure. Its the inbuilt sample superstore dataset in tableau desktop. or you can download the workbook from my tableau public profile public.tableau.com/app/profile/gurpreet.singh2669 Hope that helps
It depends on the use case and the dataset. If you dataset is more then millions rows then i wouldnt recommend it as it will be really slow in computing data point. However if you have small dataset then feel free to use it.
Hi! Great great video, done it perfectly, but only problem is my data is duplicated, so my results are wrong, as my total number of sales is double the correct one. How can I solve that? Thank you!
Thanks for your feedback. When you use data densification using path values and do cartesian join, it will create 2 values for each value in your dataset. In order to avoid double the value, you need to divide total sales by 2 as shown in the video (4:27) Hope that helps 🙂
Hi Venkata, Profit bin was already created in the superstore data set by default. If you want to create any new bins then you can do it by right clicking on a measure field and select bin. hope that helps. Cheers! Gurpreet
Hi , In this chart we are using data densification techinque to artificially create points. for that we have used "path" field with two values . In between these two values we are artificially creating points using bin. So each row gets duplicated when we join it with Path. Thats why the Sales number gets doubled. Inorder to avoid that , we divided it by 2. Hope that helps 🙂 Please feel free to reach out if you need more information.
You can say step by step like why we need to do those things and what are the trying to implement you just simply saying and I don't understand what are you trying to say
Thanks for your feedback. Will see what i can do in future tutorial to make things more clear so my audience can understand it better. In the meanwhile if you have any questions, please feel free to reach out. :-)
Thanks for your feedback. Hope this video helped you with step by step process to create dendrogram chart. Please feel free to reach out if you have any questions 😊
I love Tableau and this was a great video. But its a total waste of time. How about just using a bar chart and color by category? It takes 5 seconds and you get the same information. Probably most people here want to see a multi-level dendogram or process flow chart.
Thanks for your feedback. Yes there are lots of other ways of visualising data and as a designer we need to make sure that we get all the question answered in the dashboard and make is easy to use , looks inviting and beautiful and helps the business in decision making.
Fantastic video. Really liked the fact that you did this step by step and I was able to follow and pause. Great video. Moving onto part 2 now.
Thanks for your feedback Pritesh. Glad that it was helpful. :-)
Very helpful! Thank you!!
You are welcome Nicole. Thanks for supporting our channel 🙏
At 13:41 I'm getting Circles on the chart. and how to convert them into Bars. can you please help
Check your Percentage Adjusted calculation. You might have used Windows Sum instead of Windows Max
Can you share how it would be possible to sort the categories not by Rank (of sales) but instead a manual sort - ie I can choose if furniture is at the top regardless of sales? Thanks for your help
Thats a great question. You could use the custom sort on the dimension value rather than sales. Please try and let me know incase you need more info.. Cheers!
Great one
Thanks 🙏
Easy to follow step by step but not easy to remember all steps and calculations :)
Thanks for y our feedback. Yes, its hard to remember all steps but you can refer to this tutorial when you are building this chart. With practice you will be able to do that.
amazing video thank you!
Thanks Wendy 🙏
Awesome video! Just wondering how to sort by category in a specific order (pipeline) vs by total sales by category. I can't seem to do it with custom sorting.
You can do that by sorting in tableau calculation in a particular order. You can also do that by bringing calculated field in the table calculation. Please try that and let me know incase of any issue.
thanks for the work
You are welcome 🙏
wonderfull
Thank you! Cheers!
if you notice, in the last part when you add sheet 3 there is a higher value than the original sum of sales plz confirmed it
What if I want to show only the top 10 values in the dendrogram, not all values? I used a filter and a parameter but it didn't work
You could use a filter.
Example: Use Categories in the filter shelf.
Then edit the filter and you will see 4 tabs in the pop up window i.e. General, Wildcard, Condition & Top
Select the Top one
Then select the radio button for "By Field"
Then select top 10 (Or. what ever is your requirement)
Then select "sales" measure and aggregation of "Sum"
then click ok
All done :-)
do this in all the levels to achieve desired result
Hi, I was wondering if Sales that you are showing is not multiplied *2 - because of adding those rowspath on the beginning, isint this multiplied?
Hi , In this chart we are using data densification techinque to artificially create points. for that we have used "path" field with two values . In between these two values we are artificially creating points using bin. So each row gets duplicated when we join it with Path. Thats why the Sales number gets doubled. Inorder to avoid that , we divided it by 2. Hope that helps 🙂
Please feel free to reach out if you need more information.
What if I want to display only the top 10 sub-categories in the dendrogram based on the sales values, only top 10, not all of sub categories? How can I do it?
You could use a filter.
Example: Use Categories in the filter shelf.
Then edit the filter and you will see 4 tabs in the pop up window i.e. General, Wildcard, Condition & Top
Select the Top one
Then select the radio button for "By Field"
Then select top 10 (Or. what ever is your requirement)
Then select "sales" measure and aggregation of "Sum"
then click ok
All done :-)
do this in all the levels to achieve desired result
Is there anyway to build this without using a join to the path data? I'm using a published data source so cannot join to it
There is an another way using calculated field and parameter. Check out below blog post from Flerage brothers www.flerlagetwins.com/2019/05/intro-to-data-densification.html
Hope that helps
great video, one question though, should we use a new calculation field of sales/2 for sheet 2 and 3 since I thought the numbers are duplicated when we were using the original sales field, thanks
Yes you are correct. That seems to be an error in the video. Due to data densification, we need to divide sales by 2 . Thanks for pointing that out :-)
Can we do this chart with multiple layers? A multi level dendrogram?
cargouvu : Yes we can create this chart with multiple layers with few additional calculations. Will share the tutorial on that soon. Please stay tuned 😊
@@DataVizCanvas thanks. Right now, I am doing it using Jeff Schaffers method. This way is easier
@@DataVizCanvas When will you share it?
@@lama7559 Please see the latest tutorial on multi level dendrogram chart. :-)
ruclips.net/video/1FVwBj6pHxg/видео.html
@@DataVizCanvas thanks a lot
Can you give any resource to understand what's going on for the X part
Hello, I just had to visit my high school math ;) No other resource apart from my tutorial.
Please let me know which part you didnt understand and i will try to provide more details.
While doing an exercise for creating this chart, I found the below error under Y Axis Table Calculation
"COUNT is being called with (numerical bin), did you mean (table)? "
Hi Zabiyoddin,
Y axis table calculation is computed using specific calculation of Sub Category. You could download the dashboard from tables public using below link
public.tableau.com/profile/gurpreet.singh2669#!/vizhome/TreeDiagram_15855417594610/TreeChart
@@DataVizCanvas On the Table Calculation step of @Y I also got the same error:
"An error occurred while communicating with data source 'Sample - Superstore'
Error Code: 19841555
COUNT is being called with (numerical bin), did you mean (table)?"
When I checked the comments after getting this error, I saw that I was not alone in this error :). When I download your workbook, it looks fine, but do you have any idea why we might have encountered this error at this step? Version difference?
btw Thanks a billion for your magic!
@@MehmetSezer7 This issue was caused due to the use of "bin" with data relationship.
Upgrading to tableau desktop to 2021.2 or more will solve this.
Alternatively please use data join instead of data relationship.
Hope that helps.
Cheers!
Gurpreet
Is it possible to create this chart by "Tableau public". I could not able to paste the clipboard.
Hi Joneesh,
Please copy the data in excel file and use that as data source rather than paste as clipboard. Please try that and feel free to reach out in case of any issues 😊
Power BI supports this feature natively
Thank you
You're welcome
Hi, i need to create Dandogram for 3 levels. Could you please help me for that, i have searched and tried everything but not worked.
Hi Sandeep, please try watching tutorial in below playlist where I have shared different ways of drill down at multiple level using dendrogram chart
ruclips.net/p/PLMbGQrGl-0EuBew3uS85ZitX_Evc8oJp2
any idea of how to adjust the display when applying filters? even using containers, the dendrogran lines don't appear centralized as the sub-total is..
and great job on the video my dear!!
Hi Gustavo, Do you mean that the alignment of the dendrogram lines doesn't align with the total sales value.
In that case you can use custom alignment in text mark and make adjustments there for both sheets.
Please feel free to reach out if you need more info and would appreciate if you can share your dashboard link as it will help to investigate your issues.
Cheers!
Well explained video, sir. Can you share the dataset for the practice purposes?
Yes, sure. Its the inbuilt sample superstore dataset in tableau desktop. or you can download the workbook from my tableau public profile
public.tableau.com/app/profile/gurpreet.singh2669
Hope that helps
Is this used in business? to uncover insights?
It depends on the use case and the dataset. If you dataset is more then millions rows then i wouldnt recommend it as it will be really slow in computing data point. However if you have small dataset then feel free to use it.
Can you please share the dataset?
It’s sample superstore dataset available on tableau desktop or you can download my tableau public workbook . Hope that helps 😊
@@DataVizCanvas Thanks for your reply. Sure
my Y axis did not came in the center
I like it
Glad you liked it. Cheers!
Hi! Great great video, done it perfectly, but only problem is my data is duplicated, so my results are wrong, as my total number of sales is double the correct one. How can I solve that? Thank you!
Thanks for your feedback.
When you use data densification using path values and do cartesian join, it will create 2 values for each value in your dataset.
In order to avoid double the value, you need to divide total sales by 2 as shown in the video (4:27)
Hope that helps 🙂
Great video, I do not see step where you create profit bin
Hi Venkata,
Profit bin was already created in the superstore data set by default. If you want to create any new bins then you can do it by right clicking on a measure field and select bin. hope that helps.
Cheers!
Gurpreet
I did it.. Thanks alot, I think you are a litle bit too fast :) Thanks again. Let me try part 2
Thanks for your feedback.
I will try to keep my pace a bit slow in future videos.
Cheers!
Gurpreet
I'm going to go pick up the pieces of my head now.
I know some of these tricks can be difficult to understand. Please feel free to reach out if you need more information or clarification. Thanks!
I really didn't understand why we divide by 2 for also the @Total Sales field
Hi , In this chart we are using data densification techinque to artificially create points. for that we have used "path" field with two values . In between these two values we are artificially creating points using bin. So each row gets duplicated when we join it with Path. Thats why the Sales number gets doubled. Inorder to avoid that , we divided it by 2. Hope that helps 🙂
Please feel free to reach out if you need more information.
You can say step by step like why we need to do those things and what are the trying to implement you just simply saying and I don't understand what are you trying to say
Thanks for your feedback. Will see what i can do in future tutorial to make things more clear so my audience can understand it better. In the meanwhile if you have any questions, please feel free to reach out. :-)
It would be great if you explain every step,means why are you taking exp() function Like this....thank you
Thanks for your feedback and supporting my channel. It means a lot. Thanks
Bhai, "डेटा" hota hai not "डाटा"..baki achha hai
Thanks for your feedback. :-)
Please Share data !
You can download the dashboard form my tableau public profile and play with the dataset. Thanks 🙂
Intro nearly burst my eardrums, other than that good video.
Thanks for the feedback. Will see what I can do in future videos 😊
Tableau claims that it is very easy. But frankly speaking unless someone show process step by step, we don't even get clue to start such graphs.
Thanks for your feedback. Hope this video helped you with step by step process to create dendrogram chart. Please feel free to reach out if you have any questions 😊
I love Tableau and this was a great video. But its a total waste of time. How about just using a bar chart and color by category? It takes 5 seconds and you get the same information. Probably most people here want to see a multi-level dendogram or process flow chart.
Thanks for your feedback.
Yes there are lots of other ways of visualising data and as a designer we need to make sure that we get all the question answered in the dashboard and make is easy to use , looks inviting and beautiful and helps the business in decision making.