As I understand it, the calculation is % of promoters (score 9 or 10) minus % of detractors (score 0-6).
I assume you would ignore 88 just as you would ignore the 7 and 8 scores. But, this is not a metric I've worked with often so I'm not your best resource if you're seeking best practices around the score itself.
In terms of using Tableau, there are a few ways you could set up this calculation depending on how your data is structured and what other dimensions are in your view.
1 of 1 people found this helpful
-I use NPS daily. Here is how I did it:
-I make a case statement for Promoter and Detractor. You may need an if statement though. It depends on your case. Something like:
For your use case you may have 88 "Nulls". We call these "No scores" so as we made a calculated field for promoter and detractor, make one for "No scores"
Then I create the NPS score Calculated field:
(count([Promoter]) / count([Number of Records]) - count([No Score]) - (count([Detractor]) / count([Number of Records])-count([No Score])
You may need to play with the calculations based on how your data is structured.
Hope that helps!