The donut chart is one of the most seen charts from the time of Excel. It is usually built-in Tableau using two pie charts (one with sectors, the second with a white circle), combined using a Dual Axis. But what if another level is needed? We've got that question while developing a dashboard for a customer.
And what if we create a Sunburst chart? Step-by-step instructions from the Internet contain many calculations and additional sources. Calculations for Tableau are not a problem (it would instead not get confused), but you can not always add another source to a book. We offer a simple way to solve such issues with only one additional field; the others you will take from the existing source!
The first step to begin is creating a field point.
Then add it to the map.
Let's run away from a map to a donut chart.
Change the mark type to "Pie" and fill the Angle with a measure of Sales in the dataset. Then drag Category to Color.
Then type CTRL+SHIFT+B to zoom your circle and remove the map from the background.
We get a standard pie chart.
Now let's make a donut chart with a factoid in the middle.
Return the background with the map and add a point-field as another layer.
How to add a point-field as map-layer
Change the mark type to "Circle", then choose the white color. Drag Sales to the Label and again remove the map from the background.
Add another layer to do a 2-level donut chart. Make all steps for a pie chart and then add a Subcategory to “Detail”.
Now let's change our donut chart into a "Sunburst" type. Change the order of layers to do this.
You can add a subcategory to the Color to show the relation of the part to the whole with intense color.
You can adjust the required number of layers this way.
Something non-obvious (map layers)
allows you to get something incredible (multi-level pie charts).
Explore our possibilities
Use proved Tableau expertise
By clicking the button, you agree to the processing of personal data. We use it to stay connected.Read more