Does anyone have a way to show total NPS score (promoters - detractors) in the form of a report/dashboard?

Related products: None

Looking for a way to show our NPS score value on a report/dashboard. Any ideas would be appreciated.





Thanks!
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.
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.
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!!
The 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!