Calculate the Net Promoter Score (NPS)

NPS values are shown very frequently in brand trackers and customer satisfaction dashboards.
They are usually calculated as promoters (9,10) - detractors (0-6) and output as a percentage (*100).
To bring these values into a DataLion dashboard, all you have to do is add the corresponding formula for the calculation from the eleven-point scale to the codebook. If our NPS variable is called nps, the formula is:

{{= 100*(SUM(nps IN (9, 10)) - SUM(nps IN (0, 1, 2, 3, 4, 5, 6))) / (SUM(nps IN (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10))) }}

The long version of the formula makes sure that people who did not answer this question at all, and therefore represent missing values, are not included in the calculation. If there are no missing values, the following simple formula is also possible:

{{= 100*(SUM(nps > 8) - SUM(nps < 7)) / COUNT(*) }}

These formulas calculate the unweighted NPS scores. If each case also carries a weight (e.g. weight), the formula becomes a little more complicated, because we now have to multiply by the weights.

You then obtain the weighted NPS as follows:

{{= 100*(SUM(nps IN (9, 10) * weight) - SUM(nps IN(0, 1, 2, 3, 4, 5, 6) * weight)) / (SUM(nps IN (0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10) * weight))}}