Skip to main content
rish_singh
rish_singh
Contributor ⭐️⭐️⭐️
February 7, 2017

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

  • February 7, 2017
  • 7 replies
  • 48 views
Looking for a way to show our NPS score value on a report/dashboard. Any ideas would be appreciated.

Thanks!

      7 replies

      A
      Anonymous
      February 7, 2017
      Hey Rish, What is missing from Gainsight's NPS dashboard that you are looking for?
      rish_singh
      rish_singhAuthor
      Contributor ⭐️⭐️⭐️
      February 7, 2017
      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?
      praneet
      praneet
      Helper ⭐️⭐️⭐️
      March 6, 2017
      Hi Rish,
      Currently we do not have this capability since Reporting doesn't allow column level formula on data.
      jeremy_curry
      jeremy_curry
      Helper ⭐️⭐️
      March 23, 2018
      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.
        rish_singh
        rish_singhAuthor
        Contributor ⭐️⭐️⭐️
        March 26, 2018
        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!!
        pele
        pele
        Helper ⭐️⭐️⭐️
        March 26, 2018
        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. 
          rish_singh
          rish_singhAuthor
          Contributor ⭐️⭐️⭐️
          March 27, 2018
          Thanks, all!
          Terms & ConditionsAccessibility statement