IN vs Not IN two different cards
Is there a way to create a filter in a dashboard includes only the selected value in a card and includes everything else but this filtered value in another card? for example, if I have 10 ids, one card should have the sales amount for the specific ID I'm filtering on and another card should have average sales of the 9 other IDs that I haven't selected. I want both of these in the same dashboard using a single filter
Best Answer
-
Yes, just use include or exclude on each cards filter depending on if you want the results of the filter included or excluded.
0
Answers
-
Yes, just use include or exclude on each cards filter depending on if you want the results of the filter included or excluded.
0 -
@jessdoe I believe I share this user's question and I think the answer doesn't quite resolve this.
If I understand correctly, I believe they are asking about a scenario where there are a total of 3 cards: 1 is the filter (where the id is selected) that is enabled with interaction filters and applied to 2 other cards where the data is shown: one card filters where id IN selected id and another card then filters where id NOT IN selected id.
I tried doing as you suggested in each card, selected the dimension to filter and setting one to IN and the other to NOT IN, but the cards don't retain any information of IN or NOT IN regarding that filter unless you actually select value(s) from the filter ie. it doesn't work. When I select a value from the filter card, both subsequent cards then filter where id IN selected id rather than one doing IN and one doing NOT IN.
Is it possible to do what we're asking?
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 744 Beast Mode
- 58 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 395 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive