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

    Likert Scale varied

    Kathleen Allen

      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?

       

      Thanks for your help!

        • 1. Re: Likert Scale varied
          Shinichiro Murakami

          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
            Mark Fraser

            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
              Kathleen Allen

              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
                Mark Fraser

                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
                  Mark Fraser

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