3 Replies Latest reply on Aug 3, 2016 5:58 AM by Gagan k

    How calculate Net Satisfaction score

    Gagan k
    Gagan k Aug 1, 2016 6:11 AM

      Hi,

       

      I need to calculate Net satisfaction score for one of my reports.

       

      We have asked a satisfaction score which is rated in 4 point scale (Extremely satisfied, Somewhat satisfied, Somewhat dissatisfied, Extremely dissatisfied). So to calculate we are considering (Completely satisfied, Somewhat satisfied) as top 2 box and (Somewhat dissatisfied, Completely dissatisfied) as bottom 2 box. To get the Net satisfaction score we need to subtract  top 2 box with bottom 2 box.

       

      The challenge I am facing here is - I need to show both top 2 box, bottom 2 box and Net satisfaction score in same stack chart in tableau?

       

      Below is sample data format which I have with me. The data is in Excel format. Kindly help

       

      Overall, how satisfied are you with the work done by the team?
      Extremely dissatisfied
      Somewhat satisfied
      Somewhat satisfied
      Extremely satisfied
      Somewhat dissatisfied
      Extremely satisfied

          

      Extremely   Dissatisfied
      Somewhat Dissatisfied
      Extremely Dissatisfied
      • 1536 Views
      • Tags:
        • 1. Re: How calculate Net Satisfaction score
          Carl Slifer
          Carl Slifer Aug 1, 2016 7:02 AM (in response to Gagan k)

          Hi Gagan,

           

          Can you provide a sample of how the data is set up from within excel. The biggest issue in these cases is usually the data format.

           

          Assuming 1 row per answer In short what you will do is

          SUM( IF [SurveyQuestion] = 'Somewhat satisfied' OR [SurveyQuestion] = 'Extremely satisfied' THEN 1 ELSE 0 END)

          -

          SUM( IF [SurveyQuestion] = 'Somewhat dissatisfied' OR [SurveyQuestion] = 'Extremely dissatisfied' THEN 1 ELSE 0 END)

           

          This gives the resulting NPS.

           

          Cheers!

          Carl Slifer

          InterWorks

          1 of 1 people found this helpful
          • 2. Re: How calculate Net Satisfaction score
            Gagan k
            Gagan k Aug 1, 2016 7:44 AM (in response to Carl Slifer)

            Hi Carl,

             

            Thanks for your reply.

             

            I actually didn't get what you mean by "Can you provide a sample of how the data is set up from within excel".?

             

            If you are asking how the data format looks in the Excel format, Then below is the exact format. I have 160 response in each row.

             

             

            Also, I  need to subtract my Top 2 box with my bottom two box to get the Net satisfaction score. I need to show the result on stack graph.

             

            Overall, how satisfied are you with the work done by the our team?
            Somewhat Dissatisfied
            Somewhat Dissatisfied
            Somewhat Dissatisfied
            Somewhat Dissatisfied
            Somewhat Dissatisfied
            Somewhat Dissatisfied
            Somewhat Dissatisfied

             

            Regards

            Gagan k

            • 3. Re: How calculate Net Satisfaction score
              Gagan k
              Gagan k Aug 3, 2016 5:58 AM (in response to Gagan k)

              Hi

               

               

              Help needed here