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

# How calculate Net Satisfaction score

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
• ###### 1. Re: How calculate Net Satisfaction score

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

Hi Carl,

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

Hi

Help needed here