0 votes
1 view
in BI by (17.6k points)

I would like to subtract promoters and detractors in Tableau by creating a new column. Thanks for all the help!

Customer Type Table (I would like to create the NPS field as shown below):

+---------+------------+----------+-----------+--------------+

| Quarter | Detractors | Passives | Promoters | NPS          |

+---------+------------+----------+-----------+--------------+

| Q1 15   | 40.56      | 23.56    | 35.79     | =35.79-40.56 |

| ...     | ...        | ...      | ...       | ...          |

+---------+------------+----------+-----------+--------------+

1 Answer

0 votes
by (47.2k points)
  • Create a calculated field called NPS:

[Promoters] - [Detractors]

  • By creating this, it will add a new field to every row of your partition called NPS.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers !


Categories

...