How to dynamically adjust the maximum value in the Radial guage?
Hello All,
I am creating a card which shows Sales Goal Vs Actuals YTD across different regions. The sales goal is different for the three regions. My client wants this information to be shown in Radial guage with a quick filter for different regions. My question is how to make the Goal Value adjust dynamically in the chart basis the region selected in the quick filter. For example, if North region is selected the Goal should be 100, however, if the East region is selected the Goal Value should change to 80 in the Radial guage.
Please help.
Thanks and best regards
Nived Vats
Comments
-
Hello,
I don't think you'll be able to get what you are looking for in a radial guage, unless you are willing to create a beastmode to show percent to goal (this will dynamically change for each region and you can keep your max value set at 100%).
If you want to show sales vs goal with actuals, the closest you will be able to get to a radial chart is the "filled" chart type. See attached image. This will allow you to dynamically set a goal based on the selection in the quick filter.
Hope this helps,
Brian
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0
Categories
- 10.6K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 474 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 478 Datasets
- 214 Visualize
- 259 Beast Mode
- 2.1K Charting
- 12 Variables
- 19 Automate
- 356 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 249 Distribute
- 65 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 191 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive