3 Replies Latest reply on May 21, 2014 1:01 PM by Whit Clark

# How to directly calculate the NPS (Net Promoter Score) on Tableau?

Hi,

I read the 3d on the NPS but I didn't get the answer

In general I'd like to know how to make Tableau act on a part of a specific field

In particular, I need to calculate the NPS from a column with records in range 0-10

In particular i need something like

COUNT in the FIELD_1 all the record between 9 and 10, then / TOTAL(COUNT(FIELD_1))

that amount - (minus)

COUNT in the FIELD_1 all the records between 0 and 6, then  / TOTAL(COUNT(FIELD_1))

the result *100

I MEAN: is there a way to create directly a parameter like that on the formula?

Ciao

Riccardo

• ###### 1. Re: How to directly calculate the NPS (Net Promoter Score) on Tableau?

Hi Riccardo,

Tough to help without seeing exactly what you have, but you can possibly get there by creating calculated fields:
[Above 9] = SUM(IF [Dimension Value] = 9 OR [Dimension Value] = 10 THEN 1 ELSE 0 END)
[Below 6] = SUM(IF [Dimension Value] <= 6 THEN 1 ELSE 0 END)
[Combination Field] = ([Above 9] - [Below 6]) * 100

That may get you where you're trying to go. If you need more help, please post a packaged workbook.

• ###### 2. Re: Re: How to directly calculate the NPS (Net Promoter Score) on Tableau?

Hi,

I'm a newbie. It's only Day 2 and I'm trying to run before I can walk - but it will be a big tick if I can demonstrate to my boss that NPS can be calculated within Bime (rather than Excel).

In your solution above, how do you define [Above9] in order to use it in the calculation. I thought it would be the name of the calculated field that I'm creating, but that doesn't work.

Many thanks in anticipation of your patience,

Helen

• ###### 3. Re: How to directly calculate the NPS (Net Promoter Score) on Tableau?

Here's how I approach this problem:

NPS =

IF [RECOMMENDATION] > 8 THEN 100

ELSEIF [RECOMMENDATION] < 7 THEN -100

ELSE 0

END

To show the NPS for a group of responses, I drop the AVG(NPS) into my visualization.