5 Replies Latest reply on Mar 19, 2016 2:47 AM by Mark Fraser

# Likert Scale varied

I have results from multiple questionnaires using a 3 point Likert scale (yes, partial, no) for a certain set of questions. On some questionnaires, the value for Yes is 1 and others it is 3. I am trying to calculate all of the Yes responses using a case calculation, however Yes is used in the Likert scale for other parts of the questionnaire. Is there a calculation that can focus on the Yes responses for a set of questions?

• ###### 1. Re: Likert Scale varied

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?

Thanks,

Shin

• ###### 2. Re: Likert Scale varied

Hi Kathleen

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

Cheers

Mark

• ###### 3. Re: Likert Scale varied

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!

• ###### 4. Re: Likert Scale varied

Hi Kathleen

Thank you for the example

I assume you wish to show

Q1 50%

Q2 100%

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

Cheers

Mark

• ###### 5. Re: Likert Scale varied

if you need to use the 'score' instead - swap the Number of Records in the above formula to Score