How to create a Dendrogram Chart in Tableau
When I was trying to explore some new charts, I came up with this captivating and apprehensible Dendrogram Chart. Here I am going to create a Dendrogram chart with a combination of Bar chart.
What is a Dendrogram Chart?
A dendrogram chart is a diagram that shows the hierarchical relationship between objects. It is also called a tree diagram.
We are going to use Sample Superstore data to create a Dendrogram chart in Tableau .
Let us begin to visualize sub-category-wise sales using a Dendrogram chart.
Step 1 :
Load the Sample Superstore data into Tableau and create Union for orders
Step 2 :
We need to create some calculated fields to get the Dendrogram Chart
Path: To create a Dendrogram chart we need two points, the start point, and the endpoint. Here 0 and 200 are the start and the endpoints respectively.
Path(bin): This helps to create evenly spread data points between the start and end points (i.e 0 and 200). Create a path bin and edit the size of bins as 1.
X:We need X and Y points to draw the lines
Rank: Helps to create different lines for different subcategories.
Sigmoid: To create curves
Step 3 :
Plotting the Graph
Drag and drop X to Column and both Y and Path(bin) to Row. In path(bin) make sure the ‘show missing value’ is selected.
Change the marks to the line and move the path(bin) from Row to path in the marks and put Sub-category in color.
Edit Table Calculation to get the proper shape of the Dendrogram Chart
Right-click on X in the Rows and select compute using Path(bin)
Right-click on Y in the Columns and select compute using Path(bin)
Again Right click on Y and select Edit Table Calculation
In Nested Calculations
For Y: Select Sub-Category and deselect Path(bin)
For Rank: Select Sub-Category and deselect Path(bin)
The chart will look like the one below
To include bar chart in the Dendrogram chart we need to drag and drop the calculated field ‘size’ in size under Marks
· Right-click on Size and select Compute using Path(Bins)
· Again Right click on Y and select Edit Table Calculation
In Nested Calculations
For Percentage Adjusted: Select both Path(Bin) and Sub-Category
For Total Sales: Select both Path(Bin) and Sub-Category
Now the chart will look like this
Formatting the Chart for better Visualization
Drag and drop Sub-category and Sales_Percentage in Label under Marks
· Right-click on the label under marks and in Label Appearance edit the Text.
· Right-click on the Sales_Percentage under marks, click format and choose Percentage to get the display of percentage value in the chart.
Right click on the X and Y axis and deselect the Show header to remove the header in the chart.
This is the final outcome of the Dendrogram chart with bar chart for Sub-Category wise Sales Percentage. We can even use a simple bar chart to get the visualization for the above requirements but I always prefer to try new charts. Hope this blog will be helpful to create Dendrogram Chart. Thanks for reading!!!!!