Contributor ⭐️⭐️⭐️

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

7 replies
50 views
Translate All

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

Thanks!

A

Anonymous

Hey Rish, What is missing from Gainsight's NPS dashboard that you are looking for?

Translate

rish_singhAuthor

Contributor ⭐️⭐️⭐️

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?

Translate

praneet

Helper ⭐️⭐️⭐️

Hi Rish,
Currently we do not have this capability since Reporting doesn't allow column level formula on data.

Translate

jeremy_curry

Helper ⭐️⭐️

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.

Translate

rish_singhAuthor

Contributor ⭐️⭐️⭐️

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!!

Translate

pele

Helper ⭐️⭐️⭐️

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.

Translate

rish_singhAuthor

Contributor ⭐️⭐️⭐️

Thanks, all!

Translate

Didn't find what you were looking for?

Sign up

Welcome to the Gainsight Community