Skip to main content
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
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




Reply