5 Replies Latest reply on Oct 23, 2019 8:50 AM by Diego Parker

Hi Team,

We're trying to create a survey analysis, wherein we want to add missing answers responses as 0 to calculate percentage of total.

For e.g.

In attached workbook you'll see 3 questions, it is a survey data wherein user have to rate the chat out of 1/2/3/4/5 and we want to see user rating percentage for that particular question.

For 1st question, user have rated 1,2,3 and 5, but to calculate correct percent of total we would have to consider rating (answer) 4 as 0.

Similarly, for 2nd question user ratings are 1,2,4,5 and here we have to add rating (answer) 3 as 0.

Question no 3, is an ideal case where user have given ratings as 1,2,3,4,5 and we don't need to do anything just calculate percent of total for that particular question.

Thank you!!

Mahesh

Hi Mahesh,

Your data is incomplete and therefore you will need to do data scaffolding. Concept and method here:https://www.kenflerlage.com/2019/03/date-scaffold.html

Find the solution to your problem attached.

The key points are:

- The join calculation 1:1

- The filter

Hope this helps If does, can I ask you to mark it as helpful and correct? this will help other users to find correct answers and will allow us to close the thread. Many thanks!

Best,

Diego

p.s. we are currently collecting feedback on forums usage in order to find how can we improve it. Could you take 3 minutes answering this survey https://tableau.co1.qualtrics.com/jfe/form/SV_9pNEE9zAyKuYbop

Very much appreciated.

Hi Diego,

Yes this solution works for me. How can we show 0% instead of blank? I went through your blog and the parameter logic but somehow it's not working for me.

Thank you, I really appreciate your help.

Mahesh

Hi Mahesh,

It is currently at 0 but the label is not showing and sadly cannot be formatted in the current structure of your table. This is because of Tableau algorithm when it comes to domain completion. Please refer here for more information Populating empty cells with zero and Re: How do we display zero when there is no data ?

However, the closest approach would be to change the structure a bit to create a different table.

Find the example attached.

Hope this helps If does, can I ask you to mark it as helpful and correct? this will help other users to find correct answers and will allow us to close the thread. Many thanks!

Best,

Diego

1 of 1 people found this helpful

thank you!!