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%.
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.
sample.twbx 23.9 KB
NPS is survey data related, where you look at the percentage of good and bad responses (I had to use this in work recently!)
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
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!