Hi Community,
We have a requirement to build a dashboard that displays the percentage of Promoters, Passives, and Detractors based on a Net Promoter Score (NPS) survey.
The survey consists of the following 4 questions:
1.How time-efficient was it to first contact the support?
2.How satisfied are you with the effort the support personnel put in to ensure they understand your
inquiry?
3.The solution provided by the support personnel resolved my query, and I have no outstanding questions.
4.How would you rate our overall IT support?
Each question is rated on a scale from 0 to 10. After the user submits the survey, Calculate the average score (x) across all four questions, and then categorize the response as follows:
Promoter: If x = 9 or 10
Passive: If x = 7 or 8
Detractor: If x is between 0 and 6
We want to visualize the final output on a dashboard showing the percentage of respondents in each category (% Promoters, % Passives, % Detractors).
I’d love to hear your thoughts or suggestions on the best approach to implement this.
