Skip to content

    • Charting

    Charting

    NPS Calculation Through BeastMode

    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

    • 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.

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

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

      1. (
      2.   (SUM(CASE WHEN `NPS_Category` = 'Promoter' THEN 1 ELSE 0 END) - 
      3.    SUM(CASE WHEN `NPS_Category` = 'Detractor' THEN 1 ELSE 0 END))
      4.   / COUNT(`NPS_Category`)
      5. ) * 100
      6.  

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

    Answers

    • 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.

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

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

      1. (
      2.   (SUM(CASE WHEN `NPS_Category` = 'Promoter' THEN 1 ELSE 0 END) - 
      3.    SUM(CASE WHEN `NPS_Category` = 'Detractor' THEN 1 ELSE 0 END))
      4.   / COUNT(`NPS_Category`)
      5. ) * 100
      6.  

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

    • Member

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

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Welcome!

    It looks like you're new here. Members get access to exclusive content, events, rewards, and more. Sign in or register to get started.
    Sign In

    Quick Links

    Categories