In our example we are going to use the sample data –
Superstore available in tableau.
Step 1: Create a calculated field and Name it as ‘Donut’.
Step 2: Drag the Donut calculated field we created into the
Rows shelf twice.
Step 3: Right click on the second
instance of the field ‘Sum(Donut) shelf’
and make it a ‘Dual axis’
Step 4: Uncheck the ‘Show
header’ option in the same menu once you right click on the ‘Sum(Donut) shelf’
field.
Step 5: Drag the ‘Sales’ measure into the first
instance of Sum(Donut) shelf as below twice. Mark Sum(Sales) as label and color respectively and change the chart type to ‘Pie’
Step 6: Drag the ‘Sales’ Measure again into the Sum(Donut) (2)
shelf as below and make it a label. Here as well change the chart
type to ‘Pie’ as below.
Step 7: Now go back to Sum(Donut) shelf and adjust the size
of the pie as below. Along with the color palette you would like to use.
Step 8: Similarly adjust the size of the Sum(Donut) (2) shelf
as well. This would act as the mid-portion of the donut hence color it white
with the overall number displayed at the mid of the Donut.
Step 9: Drag the corners of the chart to adjust the view of
the chart as below.
Step 10: Drag the ‘Category’ field into the ‘Sum(Donut)
shelf’ shelf and see the magic.(You can choose any field based on the type view
you would like to see). Change the ‘Category’ field to color so that you can
see the category names on the Donut chart. Drag another instance of ‘Category’
to ‘Sum(Donut) shelf’ and make it color as below.
Step 11: Now this is an overall donut chart for sales
category by sales. If you would like to see a further split. Drag and drop the
field by which you want to split the donut into multiple donuts. In this example
we have put the ‘Region’ column into Column shelf and the results look as
below.
Hopefully you have enjoyed creating Donut chart in tableau
and implemented within you reporting environment.
Post a Comment
0Comments