radial chart max value

drewfig

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!

 

 

Valiant

For getting your max value set to 100%, you can do two things:

1. Under Chart Properties, set Range 1 to Max Value of 1

2. For the Gauge Value field, select it and choose format -> Percentage

Once you have those, you can start adding colors over different ranges using the other range values .

 

Hope this helps get you started,

ValiantSpur

 

**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.

NewsomSolutions

Just my two cents, I'm adding this since you said you were a newbie...but...IF you can do a similar conditional ETL in Magic I'd do that because the performance of Magic ETL is better than MySQL, but it's functionality may not be as great. As your data grows you may feel it the performance difference.  

drewfig

I will keep that in mind, thanks!