Looking for a way to show our NPS score value on a report/dashboard. Any ideas would be appreciated.
Thanks!
Does anyone have a way to show total NPS score (promoters - detractors) in the form of a report/dashboard?
Hey Rish, What is missing from Gainsight's NPS dashboard that you are looking for?
The NPS dashboard is great. I'm trying to get the score from the NPS dashboard to show on a overall performance report & dashboard. Does that make sense?
Hi Rish,
Currently we do not have this capability since Reporting doesn't allow column level formula on data.
Currently we do not have this capability since Reporting doesn't allow column level formula on data.
I have found another post that provides a great way to do this:
On the NPS Survey Response Object, add a formula field with "IF(JBCXM__NPSScore__c<=6,-100,IF(JBCXM__NPSScore__c>=9,100,0))" and then setup a report that shows the average of this field.
On the NPS Survey Response Object, add a formula field with "IF(JBCXM__NPSScore__c<=6,-100,IF(JBCXM__NPSScore__c>=9,100,0))" and then setup a report that shows the average of this field.
Jeremy, thanks for the note. Does the above formula show the result as -100 or 100, or instead shows as a range from -100 to 100?
Thanks!!
Thanks!!
+4The formula will Normalize the NPS to read -100, 0, or 100. Then, as Jeremy noted, averaging this new field will give you the NPS for the sample of responses in your report.
Thanks, all!
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.