Display state selected

LearningNinja · 2024-06-02T13:49:36+00:00

There was an error rendering this rich post.

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?

Find more posts tagged with

Charting

Maps

Beast Mode

AppStudio

Accepted answers

GrantSmith

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

All comments

GrantSmith

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

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of