11 Replies Latest reply on Feb 12, 2018 4:08 PM by Jim Dehner

    NPS trouble when one group is all null values

    Dennis McGinley

      Hello Tableau Experts,


      I'm running into a silly (good for business) problem when calculating NPS (Net Promoter Score) in a dashboard.


      Context: Participants are asked on a scale from 1-10 how likely they are to recommend an experience to a friend or colleague.

      9-10 = Promoter

      7-8 = Passive

      1-6 = Detractor


      NPS = Promoters - Detractors / Total Respondents


      Current working equation:

      ((SUM(IF[NPS question] >= 9 THEN 1 END) - SUM(IF[NPS question] <= 6 THEN 1 END)) / SUM(IF[NPS question] >= 1 THEN 1 END)*100)


      Problem: This equation works until one of my values is non-existent in the data.  Specifically, no one has selected a value of 6 or less, so the value simply doesn't show up in the worksheet; I don't get a null or error, it's just blank.


      Excited to hear about your solutions, many thanks in advance!