Category wise Donut chart in Tableau

Hello friends! recently I was working on some Tableau dashboards and found a very good usecase of donut charts which can be used multiple ways. Easy to use and visualize. Today we’ll be learning how to create category wise donut chart. I’ve used superstore data for the tutorial.

 

Category wise donut chart, what exactly this means? Suppose we a have a category dimension with three values A1,A2 and A3 and I want to this values in individual donut charts. So I’ve to use this method to create donut charts otherwise you wont be able to assign the colors. Check out the following steps.

This can be achieved using multiple methods but I’ll show you using Groups and Calculation field method.

Step 1. Create Groups or Calculated fields

For the first step create groups for the dimension values. Let’s say for furniture create a group in which group the other values. Check the image for reference.

 

OR for calculated fields create the calculation as below

If [Category]='Furniture' THEN 'Furniture'
ELSE 'Other'
END

Add more calculated fields for more dimension values.

2. Creating donut charts

In this step we’ll be creating donut chart in few steps. If you dont know how to create donut chart please go check my tutorial on donut chart here Donut Charts in Tableau. Below are the steps.

a. Put Number of records in rows shelf twice and set the aggregation as AVG.

b. Put the created calculated field or group in color and label.

c. in the last step put the measure you want to see in angle and that’s done.

 

Now repeat the steps for different dimension values and create different sheets. Here I am using Furniture, Technology and Office Supplies.

Now add the sheets to the dashboards according to your need.

Click on the image to view the Tableau dashboard!

 

This was pretty easy and fast tutorial on how to create category wise donut chart in Tableau.

Comment your queries and suggestions! Also let me know if you know any other method to achieve the same. Share with your friends.

Thanks for reading keep visiting analytics tuts for more tutorials.

 

 

8 comments

Leave a Reply

Your email address will not be published. Required fields are marked *