Display state selected

LearningNinja
Member
in Beast Mode
Hi,
I have a map card which has the values populated for all states. I would like to display the selected state name in a text box. However, I noticed, when no state is selected, the text box displays the state name which is in the first row of the data which is misleading. It should either be blank or print some message. How to fix this?
Tagged:
0
Best Answer
-
You could use a beast mode to display the selected state if only one is selected:
CASE WHEN COUNT(DISTINCT `State`) = 1 THEN MAX(`State`) ELSE '' END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
You could use a beast mode to display the selected state if only one is selected:
CASE WHEN COUNT(DISTINCT `State`) = 1 THEN MAX(`State`) ELSE '' END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 663 Datasets
- 119 SQL DataFlows
- 2.3K Magic ETL
- 823 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 193 Apps
- 483 APIs & Domo Developer
- 86 Workflows
- 23 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 117 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive