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?
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
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 182 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 77 Cards, Dashboards, Stories
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 9 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive