It's my first time to create a card using a radial chart type and I am having a hard time setting up the maximum value at 100%. It keeps on showing '10K%' as the max value.
See attached file, I am trying to create card that will monitor our net promoter score so I created this beastmde:
(SUM(
(CASE
WHEN `4. B` >= 9 THEN 1
END)
) / COUNT(`4. B`))
-
(SUM(
(CASE
WHEN `4. B` <= 6 THEN -1
END)
) / COUNT(`4. B`))
The current value is 78%, please help, thanks!