Calculating a Net Promoter Score

[#1]

Hello,

I am summarizing a Net Promoter Score Survey in QlickView. I have one column that asks the question would you ever recommend us? Answers can range from 1. Certain, 2, Very Likely, 3. Somewhat Likely, 4, Somewhat Unlikely, 5. Very Likely 6. Absolutely Not. I can create a nice graph that shows the distribution of the responses, but to obtain the NPS Score I have to do the follow Count the number of responses (1. Certain + 2. Very Likely) - (5. Very Unlikely + 6. Absolutely Not).

Can any one explain how I would accomplish this?

Thanks

[morganaaron · Accepted solution]

Count({<[Answer Field]={'1. Certain', '2. Very Likely'}>}[Answer Field])

-

Count({<[Answer Field]={'5. Very Unlikely', '6. Absolutely Not'}>}[Answer Field])

[#3]

Hi Arron,

Thank you for your help. this is close but didn't get me exactly what I wanted and maybe I didn't explain myself correctly.

I need to sum the count of (Certain + very likely)= Positive, then I need to sum the count of (Very Unlikely + Absolutely Not) =  negative and then the NPS = Positive - Negative

This is what I get with the answer you gave me

[morganaaron]

Hi Sue,

My solution would work to calculate the overall NPS in a text box for example (if you write it out in a text box, it will give you the number of positive - number of negative).

What are you looking for under positive and negative in the table, a count of the relevant performance scores, or do you want the NPS to be repeated across all of the scores?

[#5]

Hi Arron,

I almost have it, although I haven't made it pretty yet . How can I turn these numbers into a % of the total count?

Also I still don't seem to be able to get the NPS score. I have:

='NPS' & ' ' & Count ({<[25PerformanceRecommend]={'Certain', 'Very Likely'}>}[25PerformanceRecommend]) - Count ({<[25PerformanceRecommend]={'Very Unlikely', 'Absolutely Not'}>}[25PerformanceRecommend])

Thanks Sue

[#6]

Thank you Arron. I have it working