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
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive