You probably want to look at: WINDOW_SUM( if (whatever makes a slice green) then SUM([whatever measure you're using]) END )
Posting a sample workbook would really help here, because then I could have proved out the syntax and made sure the table calc setting was right. Without a workbook, I expect a dozen more cycles before we work out the exact syntax t use here. And we might be able to do this with LODs as well.
I've got some procrastination time this afternoon, so I threw together a donut chart with a subtotal in the middle (I've been doing some visualizations along these lines for a work project):
Here a Tableau page on Donut Chart Creation: Creating Doughnut Charts | Tableau Software
I've used a very simple calculated field for the subtotal, a more sophisticated approach opens up a lot of possibilities. Where this kind of viz can get really cool is if you create a parameter for different 'slice' sub-groupings (wish I had enough procrastination time to develop this for you).
Book1.twbx 1.2 MB
Thanks Glenn! Awesome simple solution!
Quick Follow up: I don't quite understand why "Minimum" is selected under the calculation.
- On Rows, right-click both instances of Number of Records, and then select Measure(Sum) > Minimum."
Thanks so much! You made my day!
My pleasure Michael.
I know that setting the Number of Records to Minimum has something to do with aligning slices and the inner circle properly, but I don't know how or why it does this. Max, Avg, CountD work as well. I believe it has something to do with setting up a common basis for a dual axis chart.