-
1. Re: How calculate Net Satisfaction score
Carl Slifer Aug 1, 2016 7:02 AM (in response to Gagan k)1 of 1 people found this helpfulHi 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
-
2. Re: How calculate Net Satisfaction score
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 Aug 3, 2016 5:58 AM (in response to Gagan k)Hi
Help needed here