3 Replies Latest reply on Jan 6, 2019 3:08 PM by Sarah Bartlett

# Percentages of total, but over 100% when combined

Hello Tableau experts,

Can someone please help me with my Tableau puzzle? I have an approve and not approve survey sent to people. Some people may say approve, not approve, no Comment (blank), and in some instances they are allowed to say both approve and not approve at the same time.

My data looks like this.
Question A has 12 total total respondents. 10 out of this 12 said Approve which is 83%. 9 out of this 12 said Not Approved, which is 75%.

Question B- total respondent 15, Approve 12 (80%), Not Approve 7 (47%)

Question C - total respondent 10, Approve 5 (50%), Not Approve (70%).

Question: Is it possible to show this data thru a pie chart? I wanted a donut chart (because most of my previous viz are donuts), but since the total is not equal to 100% for approve and not approve, it might be not feasible, can you help confirm? If not a pie, what is the best way to display this data? I'd like to show total respondent ,and the % Approve and % Not Approve.

Let me know please if my question is unclear and if you may have questions.

• ###### 1. Re: Percentages of total, but over 100% when combined

Hi Juhn,

Steve Wexler (Zen Master) has written some excellent blog posts for people working with survey data. You might find this one particularly useful in your case: https://www.datarevelations.com/how-to-visualize-check-all-that-apply-questions-using-tableau.html

Please let me know if this helps.

Sarah

• ###### 2. Re: Percentages of total, but over 100% when combined

Hello Sarah,

Thanks so much, That is a great piece of information as well. Thanks.

But my team has a very specific requirement, and we wanted something like in this link How to make a stacked donut chart

Just that, I will only have two stacked charts per sheet, this one has 5, but this is exactly what I am looking for. I was reading that thread but there was no steps that explain how to produce the stacked chart.

• ###### 3. Re: Percentages of total, but over 100% when combined

Hi Juhn,

I understand. Perhaps this tutorial on the Tableau Magic site will help? You could modify the instructions as per your requirements.