Forum Discussion
Calculate weighted NPS
Weighted NPS calculation help.. how to incorporate.
was finally able to figure this out by summing the weights and then doing my calculation as normal
10 Replies
Can you just create a new column that is [Value] * [Weights]?
I can't.. I will share a file with you in just a few minutes. Essentially, the weight is based on the unique response ID instead of the actual answer on the survey. For instance, each unique id is counted once "typically" however, we have weighted each respondent and for that they may be only classified at a weight of .70 instead of 1 for instance.
Below is a link to a sample file with dummy data for an example... you will notice that i have built a formula already that gives me the % of promotors detractors and passive survey takers... however, the NPS score based on the weight is stomping me. I would normally just do a simple divide for promotors, detractors, and passive but in this case the weight is not taken into consideration.
https://drive.google.com/open?id=14S4YG2X80ueSp3tMl0wqnBVUXfvIfJ0P
- That method distorts NPS
Here is a sample of the data in a better format and the excel file with the original formula.
was finally able to figure this out by summing the weights and then doing my calculation as normal
Hi,
Your second link is not working. I have downloaded your PBI file but cannot understand the result you want there. Show clearly the numbers that you are expecting and the method of calculating those number.
