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

3 жыл бұрын

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

Very helpful! Thank you!!

@DataVizCanvas

2 жыл бұрын

You are welcome Nicole. Thanks for supporting our channel 🙏

amazing video thank you!

@DataVizCanvas

2 жыл бұрын

Thanks Wendy 🙏

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

Great one

@DataVizCanvas

Жыл бұрын

Thanks 🙏

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

3 жыл бұрын

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

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

3 жыл бұрын

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

Thank you

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

thanks for the work

@DataVizCanvas

4 ай бұрын

You are welcome 🙏

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

@DataVizCanvas

6 ай бұрын

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.

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

2 жыл бұрын

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!

my Y axis did not came in the center

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

@DataVizCanvas

2 жыл бұрын

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

2 жыл бұрын

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

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.

wonderfull

@DataVizCanvas

9 ай бұрын

Thank you! Cheers!

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

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

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

3 жыл бұрын

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

3 жыл бұрын

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

@MehmetSezer7

2 жыл бұрын

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

2 жыл бұрын

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

Power BI supports this feature natively

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

5 ай бұрын

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.

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

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 🙂

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

I like it

@DataVizCanvas

9 ай бұрын

Glad you liked it. Cheers!

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

@DataVizCanvas

2 жыл бұрын

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

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

@DataVizCanvas

3 жыл бұрын

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

3 жыл бұрын

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

@lama7559

3 жыл бұрын

@@DataVizCanvas When will you share it?

@DataVizCanvas

3 жыл бұрын

@@lama7559 Please see the latest tutorial on multi level dendrogram chart. :-) kzread.info/dash/bejne/Y3qK2aSjZtOuqMo.html

@lama7559

3 жыл бұрын

@@DataVizCanvas thanks a lot

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

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!

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

@DataVizCanvas

5 ай бұрын

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.

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

@DataVizCanvas

9 ай бұрын

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

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 😊

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

@DataVizCanvas

3 жыл бұрын

Thanks for your feedback. :-)

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

@DataVizCanvas

Жыл бұрын

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

Please Share data !

@DataVizCanvas

5 ай бұрын

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

to much background music - info is useful but hard to concentrate because of background music

@DataVizCanvas

2 ай бұрын

Thanks for your feedback. Will try to make a better experience in the future tutorials.

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

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.

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.