Tough to help without seeing exactly what you have, but you can possibly get there by creating calculated fields:
[Above 9] = SUM(IF [Dimension Value] = 9 OR [Dimension Value] = 10 THEN 1 ELSE 0 END)
[Below 6] = SUM(IF [Dimension Value] <= 6 THEN 1 ELSE 0 END)
[Combination Field] = ([Above 9] - [Below 6]) * 100
That may get you where you're trying to go. If you need more help, please post a packaged workbook.
I'm a newbie. It's only Day 2 and I'm trying to run before I can walk - but it will be a big tick if I can demonstrate to my boss that NPS can be calculated within Bime (rather than Excel).
In your solution above, how do you define [Above9] in order to use it in the calculation. I thought it would be the name of the calculated field that I'm creating, but that doesn't work.
Many thanks in anticipation of your patience,
NPS1.jpg 119.0 KB
Here's how I approach this problem:
IF [RECOMMENDATION] > 8 THEN 100
ELSEIF [RECOMMENDATION] < 7 THEN -100
To show the NPS for a group of responses, I drop the AVG(NPS) into my visualization.