
2. Re: Unable to perform Table calculations with weighted NPS
Mavis Liu Oct 3, 2018 2:32 PM (in response to tanvi khanna)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
tanvi khanna Oct 3, 2018 2:55 PM (in response to Mavis Liu)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%

sample.twbx 23.9 KB


4. Re: Unable to perform Table calculations with weighted NPS
Mavis Liu Oct 3, 2018 2:50 PM (in response to Shinichiro Murakami)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
Jonathan Drummey Oct 3, 2018 3:39 PM (in response to tanvi khanna)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.

weighted nps v10.5.twbx 38.9 KB


6. Re: Unable to perform Table calculations with weighted NPS
tanvi khanna Oct 4, 2018 7:15 AM (in response to Jonathan Drummey)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
just adding notes about this so that it helps others when they come across!
Appreciate your help!