Dynamic textbox hide unless filtered
I have created a dashboard that has a US map with about 20 single values cards and dynamic textboxes surrounding it. The value cards all show the sum total when no state is selected, which is great. However, the dynamic textbox that shows the first state in the dataset when no state has been selected on the US map, which is wrong and very misleading. Is there a way to hide the dynamic textbox card when no state has been selected, or display some different message?
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.
Best Answer
-
it would be computationally expensive, but could you wrap your metric in a CASE statement that calculates if improper filters have been applied?
Example, if the metric is only correct if one state has been selected, could you do:
CASE WHEN countDISTINCt(STATE) = 1 then ... else <metric that works across all states> end
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Answers
-
it would be computationally expensive, but could you wrap your metric in a CASE statement that calculates if improper filters have been applied?
Example, if the metric is only correct if one state has been selected, could you do:
CASE WHEN countDISTINCt(STATE) = 1 then ... else <metric that works across all states> end
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Brilliant @jaeW_at_Onyx !
I created the following beast mode:
(CASE WHEN COUNT(DISTINCT `state name`) = 1
THEN CONCAT('Total Estimated Cost for ', `state name`)
ELSE ''
END)and dropped this beast mode into the Category field of the dynamic textbox and then just display the First Category in the General - Text properties.
The card is blank until I click on a state on my US map and then it shows the text I wanted.
Thanks!
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 688 Automate
- 177 Apps
- 453 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive