Sync Filters

Options
Josh_Evans20
Josh_Evans20 Member
edited June 11 in Datasets

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

  • Sean_Tully
    Sean_Tully Contributor
    Options

    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
    Options

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

  • Sean_Tully
    Sean_Tully Contributor
    Options

    Yes, the field names have to be the same.

  • Josh_Evans20
    Options

    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
    Sean_Tully Contributor
    Options

    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
    Josh_Evans20 Member
    edited June 11
    Options

    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
    Sean_Tully Contributor
    Options

    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.