radial chart max value
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!
Best Answer
-
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.2
Answers
-
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.
1 -
I will keep that in mind, thanks!
0
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有