How do you do NPS calculation in Reports Builder?

  • 1
  • Question
  • Updated 1 year ago
  • Answered
I am building out reports and dashboard for our regional managers to share our Customer Experience Survey data. I am able to include an "average NPS" score, but I am not able to calculate the NPS score against an additional criteria like "Region".

I have read that this could maybe be accomplished via MDA. I'm pretty green there so hoping for another solution or guidance to that end. 

The goal would be to have a single dashboard that shows the average score for our CSAT-style questions and then the NPS score. Each report would have a common filter for "Support Region".

Any ideas?
Photo of Ben

Ben, Champion

  • 8,312 Points 5k badge 2x thumb
  • hopeful

Posted 1 year ago

  • 1
Photo of Dan Ahrens

Dan Ahrens, Official Rep

  • 25,950 Points 20k badge 2x thumb
Hi Ben,
There's some good discussion over in this thread including a pretty novel idea on using 1,0,-1 integers to calculate an NPS score using MDA.
https://community.gainsight.com/gainsight/topics/true-nps-calculation-and-nps-widget?topic-reply-lis...
Photo of Ben

Ben, Champion

  • 8,312 Points 5k badge 2x thumb
Thanks Dan. I added a comment to Jeff's thread. I really love his idea and think it will work great. However, I am having trouble getting to the right spot to set that up. Hopefully he can help!