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
-
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 -
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.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 198 Visualize
- 254 Beast Mode
- 2.1K Charting
- 11 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 176 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive