Filtering of Cards

Mahit_0710

Hi DOMO peers, I need your HELP!
Here's the challenge: I am trying to filter a table card using a filter card. Table card is present in Dataset "custom" and filter card is present in dataset "daily" 
I have already tried few options:
Option 1: Direct filter -- Not working
Option 2: Using Same name on filter card and same name in Table card -- Not working
Option 3: Hiding respective columns in table card and then applying filter -- Not working
Option 4: Created a view by Merging Both Datasets and then applying filter -- Not working (Have observed duplicates here)
Looking forward for a response. Thanks

Data_Devon

Option 4 will be the only solution here, since filter cards work on the dataset that they are powered off of. Since the "Custom" dataset and the "Daily" dataset are different, then the two cards (the table card and the filter card) won't interact as expected.

As such, the root issue in your challenge is creating a join (merge) that behaves as you suspect it. With 0 context, it would be my guess that your join key isn't unique so duplications are happening.

Phew! Lots to unpack here, but ask away so we can help get you to a solution.

Mahit_0710

Hey! I've solved the problem. I figured out that I was adding calculated field at Card level and not at dataset level due to which filter was not working. Now when I have added it on dataset level. Now It's working! Thanks for replying😀