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

@onenumbertableau

3 ай бұрын

You are most welcome!

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

5 ай бұрын

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

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.

This was super helpful thank you!

@onenumbertableau

6 ай бұрын

You are very welcome!

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

@onenumbertableau

Жыл бұрын

You are very welcome!

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

Thanks magic man 🎉

@onenumbertableau

6 ай бұрын

You are welcome!

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

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]

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!

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

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/