NPS Calculation Through BeastMode

austinisenhart
austinisenhart Member
in Charting

I'm trying to do an NPS Calculation through a beastmode and have already converted the "NPS-Value" column in another beast mode to Scores (9-10) = Promoter, (7,8) Passive, (0-6) Detractors. I'm trying to do the promoters - detractors / total *100 function in a separate beast mode but can't get it to work properly. What would be the correct function to make this work? This is what my data looks like and I'm not able to change any columns to be a "count of Promoters, or Detractors".

2024-08-14_140744.jpg

Best Answer

  • ArborRose
    ArborRose Coach
    Answer ✓

    For Net Promoter Score (NPS), you'll want to create a formula that counts the number of Promoters, Detractors, and Total Responses, and then applies the NPS formula.

    You should have a column that contains the net promoter scores and another one for your calculated Promoters, Passives, and Detractors. You should have your column already categorized with "Promoter", "Passive", and "Detractor" values.

    You'll need beast modes for counting Promoters, another for counting Detractors, and one for counting Total Responses.

    COUNT(CASE WHEN `NPS_Category` = 'Promoter' THEN 1 ELSE NULL END)
    COUNT(CASE WHEN `NPS_Category` = 'Detractor' THEN 1 ELSE NULL END)
    COUNT(`NPS_Category`)

    And then create a new Beast Mode to calculate NPS using the formula.

    (
    
  (SUM(CASE WHEN `NPS_Category` = 'Promoter' THEN 1 ELSE 0 END) - 
    
   SUM(CASE WHEN `NPS_Category` = 'Detractor' THEN 1 ELSE 0 END))
    
  / COUNT(`NPS_Category`)
    
) * 100

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

Answers

  • ArborRose
    ArborRose Coach
    Answer ✓

    For Net Promoter Score (NPS), you'll want to create a formula that counts the number of Promoters, Detractors, and Total Responses, and then applies the NPS formula.

    You should have a column that contains the net promoter scores and another one for your calculated Promoters, Passives, and Detractors. You should have your column already categorized with "Promoter", "Passive", and "Detractor" values.

    You'll need beast modes for counting Promoters, another for counting Detractors, and one for counting Total Responses.

    COUNT(CASE WHEN `NPS_Category` = 'Promoter' THEN 1 ELSE NULL END)
    COUNT(CASE WHEN `NPS_Category` = 'Detractor' THEN 1 ELSE NULL END)
    COUNT(`NPS_Category`)

    And then create a new Beast Mode to calculate NPS using the formula.

    (
    
  (SUM(CASE WHEN `NPS_Category` = 'Promoter' THEN 1 ELSE 0 END) - 
    
   SUM(CASE WHEN `NPS_Category` = 'Detractor' THEN 1 ELSE 0 END))
    
  / COUNT(`NPS_Category`)
    
) * 100

    ** Was this post helpful? Click Agree or Like below. **
    ** Did this solve your problem? Accept it as a solution! **

  • austinisenhart
    austinisenhart Member

    Thanks for the feedback. I had to make an edit to the ETL to rename my columns but this formula worked!

Categories