Honestly not clear with your question here.
From what i understand the data coming from sharepoint portal gets stored in backend database tables and you want to create a tableau dashboard on top of the data.is this correct? I believe there are only two columns.
Can you attach an excel with some dummy data or a workbook if possible.
Sorry I was not clear...Here is an example. The N/A's should count as Yes.
Question 1 Question 2 Question 3 Yes Yes Yes No Yes N/A Yes No N/A No Yes Yes No No No
I would like to display all the questions on one worksheet with each question showing the percentage of Yes(and N/A).
Question 1 40%
Question 2 60%
Question 3 80%