6 Replies Latest reply on Oct 4, 2018 7:15 AM by tanvi khanna

# Unable to perform Table calculations with weighted NPS

Hi,

I have survey data in the following format and need to calculate the weighted NPS:

 time client gender age region unit end? NPS-calculated Weighting W1 2017 client1 M 35 to 49 US a 6 -1 0.1 W1 2017 client2 F 50 to 64 US b 9 1 0.11 W1 2017 client3 M 18 to 34 CA c 10 1 0.12 W1 2017 client4 F 65+ CA d 8 0 0.14 W1 2017 client5 M 18 to 34 ASIA c 0 -1 0.12 W2 2017 client6 F 18 to 34 US e 10 1 0.07 W2 2017 client7 F 35 to 49 ASIA f 9 1 0.04 W2 2017 client8 F 35 to 49 US b 9 1 0.05 W2 2017 client9 M 50 to 64 ASIA h 6 -1 0.06 W1 2018 client10 F 18 to 34 CA y 10 1 0.05 W1 2018 client11 F 35 to 49 US g 5 -1 0.02 W1 2018 client12 M 50 to 64 ASIA h DK null 0.11 W1 2018 client13 F 50 to 64 CA a 8 0 0.01

Desired in tableau:

formula: %promoters = sum (promoter’s weights) / total weight of all respondents

 weighted scores %promoters 49% %passives 17% %detractors 34% %NPS 16%

I created weights by promoter/detractor/neutral in tableau and total weight also that is needed in formula, but unable to do any table calculations since all are aggregated. Percentage of total is not working - always giving 100%

any help is highly appreciated!

• ###### 1. Re: Unable to perform Table calculations with weighted NPS

Pretty much confused.

What is NPS ? and where you get this percentage (which is not 100% in total)

and where is the category of above?

Thanks,

Shin

• ###### 2. Re: Unable to perform Table calculations with weighted NPS

Hi Tanvi,

Have you got a sample workbook?

Could you do a normal calculation rather than a table calculation work out the % of total? e.g.

Promoters by Weight/Total Weight etc, ultimately giving you 3 measures where the total of the 3 equals 100%.

Thanks,

Mavis

• ###### 3. Re: Unable to perform Table calculations with weighted NPS

Hi Mavis,

Sure attaching the tableau workbook.

I tried doing the normal percentage of total - it does not give me what I am expecting.

I don't know - I am doing some silly mistake I guess.

This is what I want:

 weighted scores %promoters 49% %passives 17% %detractors 34% %NPS 16%

where %promoters =sum(promoters weights)/all weights and so on.

so %promoters+%passives+%detractors=100%

• ###### 4. Re: Unable to perform Table calculations with weighted NPS

NPS is survey data related, where you look at the percentage of good and bad responses (I had to use this in work recently!)

• ###### 5. Re: Unable to perform Table calculations with weighted NPS

Hi,

Since the Detractors/Neutral/Promoters by weight are aggregated and the total weights is aggregated we can do a division of [Detractors by weight]/[total weight] to get a % Detractors score, and so on. Here's a view:

v10.5 workbook is attached.

• ###### 6. Re: Unable to perform Table calculations with weighted NPS

Thank you very much this works! I tried without making the columns but only using NPS (-1,1,0) with a split of detractors, passives and promoters.

%nps = your formula works + I tried another one which is weight of promoter- weight of detractor / total weight