It must be easy to be done thru Tableau, but could you share the sample workbook with excel or text file as a starting point?
As Shin indicates, this is quite possible, it just depends on your data.
Here is my sample data, I have 3 question groups, each with 3 questions
I only want to return values for groups A and C
Hopefully you can see below...
IF [Question Group] = 'A' AND [Reponse] = 'Yes' THEN 3
ELSEIF [Question Group] = 'A' AND [Reponse] = 'Partial' THEN 2
ELSEIF [Question Group] = 'A' AND [Reponse] = 'No' THEN 1
ELSEIF [Question Group] = 'C' AND [Reponse] = 'Yes' THEN 3
ELSEIF [Question Group] = 'C' AND [Reponse] = 'Partial' THEN 2
ELSEIF [Question Group] = 'C' AND [Reponse] = 'No' THEN 1
ELSE NULL END
I could of course restrict it to just A, to just Yes or any combination...
I hope that gives you a start, if you have any questions, please let us know.
If you could provide some example data, we could make it more accurate to your situation
Book1.xlsx 8.1 KB
Hi Mark and Shin,
Thanks for your help with this. I created this very basic sample workbook to help out. It may help to state that the end goal of this is to identify the total number of Yes responses in order to calculate a % of the total. Essentially the % of Yes/Total responses. I tried using Mark's calculation but got an error saying regarding string to boolean.
I appreciate all the help!
Likert Scale Varied.twbx 11.9 KB
Thank you for the example
I assume you wish to show
and overall 66.67%
That's as I have done it in the attached.
The formula I used -
IF ATTR([Answer])='yes' THEN SUM([Number of Records])/TOTAL(SUM([Number of Records])) ELSE NULL END
Summarised by question, with answer on detail
Hope that's as you need, if you have any questions, please let me know
Likert Scale Varied.twbx 16.8 KB
if you need to use the 'score' instead - swap the Number of Records in the above formula to Score