How to create Dendrogram Chart in Tableau| Single Level Drill down| Decision Tree Part I

[@PriteshRPatel-lr5uh]

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.

[@DataVizCanvas]

Thanks for your feedback Pritesh. Glad that it was helpful. :-)

[@nicolelily]

Very helpful! Thank you!!

[@DataVizCanvas]

You are welcome Nicole. Thanks for supporting our channel 🙏

[@ashameti6008]

At 13:41 I'm getting Circles on the chart. and how to convert them into Bars. can you please help

[@erhssara9545]

Check your Percentage Adjusted calculation. You might have used Windows Sum instead of Windows Max

[@hgoose95]

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

[@DataVizCanvas]

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!

[@cococnk388]

Great one

[@DataVizCanvas]

Thanks 🙏

[@gabrielad1857]

Easy to follow step by step but not easy to remember all steps and calculations :)

[@DataVizCanvas]

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.

[@MoooMooMoo]

amazing video thank you!

[@DataVizCanvas]

Thanks Wendy 🙏

[@metalfaceoff945]

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.

[@DataVizCanvas]

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.

[@midunsathiyamoorthy593]

thanks for the work

[@DataVizCanvas]

You are welcome 🙏

[@mahendragupta9599]

wonderfull

[@DataVizCanvas]

Thank you! Cheers!

[@jainikkochar1610]

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

[@lama7559]

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

[@DataVizCanvas]

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

[@karolinaroz1963]

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?

[@DataVizCanvas]

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.

[@lama7559]

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?

[@DataVizCanvas]

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

[@proplexgamez5316]

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

[@DataVizCanvas]

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

[@robertofirmino5283]

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

[@DataVizCanvas]

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]

Can we do this chart with multiple layers? A multi level dendrogram?

[@DataVizCanvas]

cargouvu : Yes we can create this chart with multiple layers with few additional calculations. Will share the tutorial on that soon. Please stay tuned 😊

[@cargouvu]

@@DataVizCanvas thanks. Right now, I am doing it using Jeff Schaffers method. This way is easier

[@lama7559]

@@DataVizCanvas When will you share it?

[@DataVizCanvas]

@@lama7559 Please see the latest tutorial on multi level dendrogram chart. :-) kzbin.info/www/bejne/Z3e5qHWga9V7rsk

[@lama7559]

@@DataVizCanvas thanks a lot

[@ShivamTiwari-on2kl]

Can you give any resource to understand what's going on for the X part

[@DataVizCanvas]

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.

[@zabiyoddinshaikh9962]

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)? "

[@DataVizCanvas]

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]

public.tableau.com/profile/gurpreet.singh2669#!/vizhome/TreeDiagram_15855417594610/TreeChart

[@MehmetSezer7]

@@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!

[@DataVizCanvas]

@@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

[@jineeshkb1704]

Is it possible to create this chart by "Tableau public". I could not able to paste the clipboard.

[@DataVizCanvas]

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 😊

[@athawanproductions9345]

Power BI supports this feature natively

[@chanduy1843]

Thank you

[@DataVizCanvas]

You're welcome

[@sandeepkumaryadav6675]

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.

[@DataVizCanvas]

Hi Sandeep, please try watching tutorial in below playlist where I have shared different ways of drill down at multiple level using dendrogram chart kzbin.info/aero/PLMbGQrGl-0EuBew3uS85ZitX_Evc8oJp2

[@gustavosantiago6679]

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!!

[@DataVizCanvas]

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!

[@abhisekhnayak9841]

Well explained video, sir. Can you share the dataset for the practice purposes?

[@DataVizCanvas]

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

[@MohammedArshadxWF]

Is this used in business? to uncover insights?

[@DataVizCanvas]

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.

[@ArcticCool1]

Can you please share the dataset?

[@DataVizCanvas]

It’s sample superstore dataset available on tableau desktop or you can download my tableau public workbook . Hope that helps 😊

[@ArcticCool1]

@@DataVizCanvas Thanks for your reply. Sure

[@sri29ghat]

my Y axis did not came in the center

[@mohammadzaman7383]

I like it

[@DataVizCanvas]

Glad you liked it. Cheers!

[@datosdefutbol]

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!

[@DataVizCanvas]

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 🙂

[@venkatagavili6249]

Great video, I do not see step where you create profit bin

[@DataVizCanvas]

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

[@SalientTruth]

I did it.. Thanks alot, I think you are a litle bit too fast :) Thanks again. Let me try part 2

[@DataVizCanvas]

Thanks for your feedback. I will try to keep my pace a bit slow in future videos. Cheers! Gurpreet

[@moleculist7978]

I'm going to go pick up the pieces of my head now.

[@DataVizCanvas]

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!

[@ibrahimfadhili6621]

I really didn't understand why we divide by 2 for also the @Total Sales field

[@DataVizCanvas]

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.

[@gajasankarraja6414]

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

[@DataVizCanvas]

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. :-)

[@souravchakraborty4397]

It would be great if you explain every step,means why are you taking exp() function Like this....thank you

[@DataVizCanvas]

Thanks for your feedback and supporting my channel. It means a lot. Thanks

[@sambahadur7218]

Bhai, "डेटा" hota hai not "डाटा"..baki achha hai

[@DataVizCanvas]

Thanks for your feedback. :-)

[@RBP29091983]

Please Share data !

[@DataVizCanvas]

You can download the dashboard form my tableau public profile and play with the dataset. Thanks 🙂

[@ranjeet9868]

Intro nearly burst my eardrums, other than that good video.

[@DataVizCanvas]

Thanks for the feedback. Will see what I can do in future videos 😊

[@SK-um6xl]

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.

[@DataVizCanvas]

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 😊

[@EricKnutson-sw7ug]

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.

[@DataVizCanvas]

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.