Sync Filters
How do I sync filters from two different data sets?
I have one table that has all of my data with products sold then in another table that has current inventory. I would like the filters in the app studio to filter them both down. Would I need to just have two separate filters or is there a way to sync them up?
Both data sets have the same column of Model name.
Answers
-
If the field you want to filter on exists on both datasets and has the same values, one filter should work on both.
0 -
How do I tell the system which columns are the same? Do they need to have the same name?
0 -
Yes, the field names have to be the same.
0 -
They both have the same column name but it doesn't seem to be working. How does DOMO know they are related fields if there are different tables?
0 -
I'm not sure of the how, but I just tested it with two cards using two different datasets that have a shared field, and the filter worked on both. Maybe the field names aren't exactly the same? Or the value you're filtering on is only in one of the datasets?
0 -
Does one card come from one data set then the other card with the other data set? When you say shared field are they joined or just has the same name? I checked and they are exactly the same in terms of text and case
0 -
Yes, each card was from a different dataset, not joined. By "shared field" I meant they both contained a field with the same name and values.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 299 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 681 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 9 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 33 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive