Skip to main content
Question

True NPS Score on a Dashboard

  • October 19, 2018
  • 2 replies
  • 170 views

jaw
Forum|alt.badge.img
  • Contributor ⭐️⭐️⭐️⭐️⭐️
Hi there, 

I am looking to create a NPS Widget report using report builder that shows the true NPS calculation based on the CSAT survey the CSM team sent out via Gainsight. 

I am able to see the current nps results within the survey but having trouble figuring out how to display this information in a dashboard. Is there a way of doing this other than showing the average NPS score on a dashboard?

Thanks,
Jasmine

2 replies

pele
Forum|alt.badge.img+4
  • Helper ⭐️⭐️⭐️
  • October 19, 2018
Pretty popular topic. There is a way to get this surfaced in a dashboard, needs a bit of configuring with an additional Salesforce formula field. Jeff's and Seth's comments about midway through the thread here give a pretty good explanation of how this is done.

Essentially, you'd create a formula field with something like:

IF(JBCXM__NPSScore__c<=6,-100,IF(JBCXM__NPSScore__c>=9,100,0))

Then, in Gainsight, you can create a widget that aggregates this field by AVG and that will calculate NPS.

Hi,

please find the document having the latest chnages to get the true NPS.

https://community.gainsight.com/conversations/true-nps-is-here-5d03e65be4b0690f77930de4