How do I force a Filter to have a value?

I have a dataset that looks something like this:
I want to build a card that shows the Q over Q difference and allow the user to filter by Region. But I also need to either have the filter always have a value, i.e., not allow the user to unselect all values, or show the difference between the 'Global' values when none of the region values are selected.
For example. If I filter on 'AMER' I should see and the card I built does show this:
This is just Q2 - Q1 or 80.4 - 78.2 This works fine. And if I select 'Global' in my filter I see this:
...again this works fine and is what it should be, 79.2 - 79.8
HOWEVER, if the user clicks on 'Global' once again and therefore unselects all values on the filter the results go to this:
...which is the sum of all Q2 values minus the sum of all Q1 values. The user may think by unselecting all filtered Region values they will see the 'Global' value. However, they see the sum of all of the values which is incorrect and these scores are not additive.
So, is there a way to force the filter to have a value?
Or is there another way of going about this?
Thank you.
Answers
-
There isn't a way to force a filter to have a value currently. Typically in this case I'll have a text box on the page with a beast mode that checks to see if the distinct count of records (in your case Region) is more than 1 I'll return a string stating to select only one value as a warning.
CASE WHEN COUNT(DISTINCT `Region`) > 1 THEN 'Please select only one region' 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
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 666 Datasets
- 827 Beast Mode
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 46 Calculations & Variables
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- 122 Workflows
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 117 Community Announcements
- Automate
- 5K Archive