I’m looking for a way to create a single vis that calculates an NPS score ((Promoters - Detractors) / Total Respondents)*100
My data is laid out with 1 row per survey response - each response has a score from 0 - 10.
In my data cube, I’m using a calculated element to categorise each response into either a Promoter, Passive or Detractor.
So now I have a data set that has each respondent on each row with their score and category.
I want to find an easy way to perform the [((Promoters - Detractors) / Total Respondents)*100] calculation in a visualisation.
At the moment I have 3 separate Data Labels that contain the values in the equation and then I’m using a Formula Visualization to perform the calculation.
The way I’m currently doing it seems like a sledgehammer to crack a nut. Anyone got any ideas how to do this all within one vis? I only want to display the score