How to Build Donut Charts in Tableau

Connect with us:
•Upcoming Tableau Classes: www.eventbrite...
•Subscribe to the OneNumber Newsletter: onenumber.biz/...
•Follow Ollie Linley on LinkedIn: / oliverlinley
Description:
Donut Charts are a very visually-appealing chart type, used to show part-to-whole relationships. They’re simple and effective, and are a great tool to add to your dashboarding arsenal. While they’re not a built-in chart type in Tableau (unlike a bar chart, pie chart, or line graph), we can build them with a few extra steps!
All we need to do to start building some awesome donut charts is to work out the percent of total for the measure you’re working with, and then calculating the remainder percentage. After that, we’re all good to go!
I’ll walk you through how to do it in this week’s video!
And if you’re interested in leveling up your Tableau calculations skills so you can build awesome charts like this, why not come along to our Mastering Tableau Calculations Course from February 8-9? There isn’t another course out there to get you comfortable with Tableau Functions like this one! We’d love to see you there.
Resources:
• Example Tableau Workbook: public.tableau...
•Advanced Donut Charts Video: onenumber.biz/...
Connect with us:
• Mastering Tableau Calculations Course: onenumber.us17...
• Subscribe to the OneNumber Newsletter: onenumber.biz/...
• Follow Ollie Linley on LinkedIn: / oliverlinley

[@zeeshanahmed9719]

Thank you very much, typing 0 in rows shelf is awesome trick.

[@onenumbertableau]

You are most welcome!

[@jiancarlochua5346]

thank you very much SIR!! In all the donut or gauge chart in youtube, only this one works as expected you saved my life sir! thanks!!

[@onenumbertableau]

Thank you for letting us know, we're so glad it helped!

[@carolefischer2199]

Hello Ollie - The pull-out would give details of a subset of values that are aggregated and lumped into one segment of a pie chart (like a grouping called 'Other') for example with 10 smaller categories. The pull out would show the counts/percentages of these multiple smaller categories. So it would be a pie (donut) chart with one segment called 'Other' - then is a smaller (satellite) donut the values of the "other' category would be shown.

[@axelmaurelangu9398]

Thank you so much cause that's exactly what I wanted to do

[@onenumbertableau]

You are very welcome!

[@melissahawkins162]

This was super helpful thank you!

[@onenumbertableau]

You are very welcome!

[@carolefischer2199]

Ollie - great fun learning the step-by-step from your TH-cam video. I am looking forward to creating these. I just spent many hours trying to create a 'pull-out donut' chart in excel with about 15 categories in the 'pull-out' section. Not sure if there is another training video that you might be interested in exploring? Many thanks!

[@onenumbertableau]

Thank you Carole! And that's interesting. When you say pull-out donut, do you mean something like this? support.microsoft.com/en-us/office/present-your-data-in-a-doughnut-chart-0ac0efde-34e2-4dc6-9b7f-ac93d1783353#:~:text=To%20pull%20out%20individual%20slices,the%20center%20of%20the%20chart.

[@raulpacheco7617]

Thanks magic man 🎉

[@onenumbertableau]

You are welcome!

[@luckymadhoo]

Nicely explained mate. Can you show how to create speedometer chart?

[@chun8230]

This video is very helpful, thank you for sharing.
I got one question, i'm calculating the fulfillment ratio (=Actual receiving quantities/agreed quantities), example that achieved percentage is 50%, then the donut chart shows half green(achived) and half yellow(not achived), if the achived percentage exceeds 100%, then how to make donut chart shows fully green? thank you.

[@onenumbertableau]

Great question! We are working on a follow-up video now to make the slice colors dynamic. You'll need to utilize the "Use Separate Legends" feature on Measure Names on color to get it to work. The high level gist of it can be found here: onenumber.biz/blog-1/2022/2/15/multiple-color-legends-for-a-single-measure-in-a-tableau-highlight-table

[@esmeelouise_]

I found a solution that worked for me. I have a field named "% Lead progress" and "% Leads needed". This last one is just 1-[% Lead progress]. Instead of using "% Leads needed" in the donut chart, I used this calculation:
if [%Leads needed]

[@moxie1189]

One thing I have never see in a Tableau tutorial, is a dynamic donut. For example, a parameter embedded in a calculated field. Hypothetically, say the parameter consists of four regions: North, East, South & West. You change the parameter region value and the donut dynamically changes in terms of parts to the whole.

[@onenumbertableau]

Interesting. Do you have an example of this somewhere on the web? We'd be curious to see what you have in mind!

[@TH-vw4qn]

Good tutorial but the donut charts does not look like the one from the thumbnail.

[@onenumbertableau]

Thank you! Are you referring to the slices changing colors or the rounded bars in the donut sections?

[@TH-vw4qn]

@@onenumbertableau Rounded bars, would you please create the exact one from the thumbnail? It looks much better than the one from the video.

[@onenumbertableau]

@@TH-vw4qn Unfortunately there isn't a simple way to round the bars in the donut chart but you might check out Toan Hoang's blog post here: tableau.toanhoang.com/tableau-qt-rounded-doughnut-chart/

[@onenumbertableau]

Check out Part 2, 'Advanced Donut Charts' here! onenumber.biz/blog-1/2022/3/15/advanced-tableau-donut-charts
Need help making your own donut chart? Sign up for an hour with Ollie here! www.eventbrite.com/e/tableau-office-hours-with-ollie-linley-eastern-time-tickets-439769641837