Datasets
Datasets
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.
Welcome!
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
Welcome!
Welcome!
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive