I have 3 values in a field called Score Grouping. The values are Promotor, Passive and Detractor. I have counted the number of IDs in each field using CountD(id). I have then duplicated that field and used the percent of total table calc to show percentages.
If I wanted to subtract the Promotor % from the Detractor % how would I do that? I am supposed to provide an overall number for the company with that calc through Tableau dashboards. Additionally, I am starting with the company as a whole. I will need to do that for each branch. Every branch should have a percentage break out by Promotor, Passive and Detractor. Then a value coming from Promotor percentage minus detractor percentage.
Im not far, but here is a snap of the data. I have considered pivoting the 'Score Grouping' field in prep to have each value (Promotor, Passive, Detractor) as a column but unsure the next step to aggregate. Any help would be great.
Hi @Drew Petersohn
i see you are calculating the Net Promoter Score and trying to use a table calculation - I have a client that uses NPS and found you need to use lods as show here https://jimdehner.com/2020/11/18/faq-series-net-promoter-score/
Jim
