Sync Filters

Josh_Evans20 · 2024-06-11T12:26:33+00:00

There was an error rendering this rich post.

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.

Find more posts tagged with

Accepted answers

All comments

Sean_Tully

If the field you want to filter on exists on both datasets and has the same values, one filter should work on both.

Josh_Evans20

How do I tell the system which columns are the same? Do they need to have the same name?

Sean_Tully

Yes, the field names have to be the same.

Josh_Evans20

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?

Sean_Tully

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?

Josh_Evans20

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

Sean_Tully

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.