How to Build Donut Charts in Tableau

[@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

[@MrPlskjs]

The only video I found that really helped! Thank you very much!

[@onenumbertableau]

That's so good to hear, thanks for letting us know!

[@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!

[@zeeshanahmed9719]

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

[@onenumbertableau]

You are most welcome!

[@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.

[@melissahawkins162]

This was super helpful thank you!

[@onenumbertableau]

You are very welcome!

[@carolefischer2199]

Ollie - great fun learning the step-by-step from your KZbin 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.

[@axelmaurelangu9398]

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

[@onenumbertableau]

You are very welcome!

[@raulpacheco7617]

Thanks magic man 🎉

[@onenumbertableau]

You are welcome!

[@katrina8817]

Thanks ❤

[@onenumbertableau]

You're welcome!

[@luckymadhoo]

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

[@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!

[@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]

[@angelinam6855]

Wouldn’t have been productive for tableau to include donut chart as a visual instead of creating one from scratch every time?

[@Tanmayislivee]

I have 4 order priority in dataset and i want to make 4 donut charts for the same where each chart shows the % of orders fulfilled in specific order priority but im not able to make it can anyone help me out

[@onenumbertableau]

Hey - you could make 4 donut charts by dropping your Order Priority field onto columns and then performing a manual sort on order priority to get it into the order you want! Hope that helps!

[@Tanmayislivee]

@@onenumbertableau well by doing that it creates 4 donuts with outer circle fully colored But I want the % of that order priority inside that donut and also I want that the outer circle of the donut should get colored according to the % of the order priority so how can I do this?

[@onenumbertableau]

@@Tanmayislivee Got you. I misunderstood you! You'll need to make four fields to do this and drop them onto Measure Values. You should be fine with percentages.If it doesn't work, let me know!

[@onenumbertableau]

@@Tanmayislivee Hey - sure, it's a bit complicated to explain in a KZbin comment. You're welcome to schedule an Office Hour if you'd like some hands on help here: www.eventbrite.com/e/tableau-office-hours-with-ollie-linley-tickets-439769641837?aff=oddtdtcreator

[@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/