I'm trying to calculate the NPS, Net Promotor Score, using Dashboard.
NPS is % of Promotors (9-10) - % of Detractors(0-6)
First to put it in context:
We are going to use a Survey123.
Using Survey123 I can calculate things, but not the pertenge because it's works with that response. Not the % of total.
Then I tried with Arcade Field Caculator in Arcgis Online, but if I get an other response it is null.
Then if I use Arcade in the Pop-Up, but at the moment, we can't use that field in Dashboard.
I tried directly with Dashboard, I can get % of Promotor and % of Detractor. But I can't do a substracction.
Then in Pro I tried to put attributes rules, but it's the same as Survey123. It's works in the same row.
So could someone to help me ? Or someone who has done it? Could give me any clue?