Tableau Bitesize: Progress To Target - Donut Chart
This post will go through the process of creating a donut chart in Tableau
Actually – to call it a donut chart is a little misleading – what we’re actually doing it creating a pie chart with a circle over the top of it, but hey, if it looks like a donut, quacks like a donut….
This, together with the other blog posts relating to the ‘Progress to Target’ viz will use the ‘progress_dummy_data.csv’ file attached below:
This file contains dummy data related to 5 teams – it has just 3 columns: ‘ID’, ‘Team Name’, and ‘Target Met’ and is therefore recording which teams have met their particular (generic) target
As with the other blog posts, start off by creating a parameter from the ‘Team Name’ field:
Next, create a calculated field called ‘Team Filter’ as follows:
[Team Name] = [Team Name Parameter]
Then drag this to the Filters card and select ‘True’
You can then choose a team from the list of parameters – in this example I will be using ‘team_3’
To start off with the donut chart, we’ll need to create a few more calculated fields
0
MIN(0)
‘Total Met Target’:
SUM(IIF([Met Target],1,0))
This one simply records a ‘1’ value whenever the team has a TRUE value for the ‘Met Target’ field which we can then use to calculate the %
Total Not Met Target
SUM(IIF([Met Target],0,1))
This will simply record the inverse of the previous calculation
% Met Target
[Total Met Target] / COUNT([progress_dummy_data.csv])
OK and we’re ready to go
Start off by dragging the ‘0’ field twice onto the ‘Rows’ shelf and set it as ‘Dual Axis’
Synchronise and hide the headers, then remove all lines and borders
Next, change the ‘bottom’ layer (the ‘0’ field on the left of the dual axis) to a pie chat and the top / right one to a circle
On the Pie Chart mark, drag ‘Measure Names’ to Colour and ‘Measure Values’ to Size then leave only the fields AGG(Total Met Target) and AGG(Total Not Met Target) (ensuring that AGG(Total Met Target) is on the top
On the Circle mark, change the colour to white and reduce the size slightly
Change the colours on the pie chart to those of your choosing (I usually go for a washed out grey for the count field then a bolder colour for the other, as in the above image)
On the Circle mark, drag the ‘% Target Met’ field onto label and format to your choosing
And that’s all there is to it! I hope you found this useful but if you have any questions – please feel free to leave a comment below!
Because of the nature of the chart – it’s recommended that this would only be used in scenarios where 100% is the maximum value you would expect to see
The workbook on Tableau Public below contains all of the chart types used in the ‘Progress to Target’ series, including this one
Thinking about making particle physics approachable, I find the smaller practical questions more interesting than a quick conclusion. An everyday analogy can help introduce an idea while still leaving room to explain its limits. It gives me a more concrete starting point for thinking about particle physics basics. I would be interested in a simple example, because it is often the ordinary details that make an idea memorable. Which comparisons make particle physics easier to picture without creating misconceptions?
When it comes to connecting school learning with Wasilkow, I would rather understand one useful detail properly than rush through a long list of ideas. A project about nearby places can give students a shared starting point for research. This is why I would approach Wasilkow school community with a specific question rather than a fixed expectation. The part I would like to explore further is what happens when the idea meets a real situation with its own limitations. Which community questions could students investigate through interviews or observation?
Thinking about making collaborative classroom projects work, I find the smaller practical questions more interesting than a quick conclusion. A group task becomes easier to follow when everyone understands their own contribution. It makes me curious about the practical side of classroom project teamwork. The part I would like to explore further is what happens when the idea meets a real situation with its own limitations. How should students share responsibilities without leaving one person to do everything?
I can see why connecting values with everyday school life would invite discussion, since different people will bring different experiences to the same question. Kindness becomes easier to understand when it appears in ordinary classroom situations. It makes me curious about the practical side of values based education. I can imagine different answers depending on the situation, so I would want to understand the context before drawing conclusions. How can a school discuss values while leaving room for students' questions?
Thinking about applying business training to everyday work, I find the smaller practical questions more interesting than a quick conclusion. A useful training exercise should connect a new idea with a situation people actually encounter. That is the kind of detail I would keep in mind while exploring practical business training. I do not have a settled view yet, but this seems like a good place to slow down and look more closely. How would you check whether a workshop changes behaviour after it ends?