Cross-Dataset Filtering

Q&A
, , , ,
1

Hi Team,

I’m working on a dashboard with two separate datasets and need help with cross-dataset filtering:

My Setup:

  • Dataset 1 (Territory Lookup): Multiple rows per seller - one row per territory assignment (territory_id, seller_id, seller_name). Each seller can have up to 5,000 territories.

  • Dataset 2 (Seller Analysis): One row per seller with performance metrics (seller_id, quota, attainment, revenue, etc.)

What I’m Trying to Achieve: Users should be able to:

  1. Search for one or multiple territory IDs

  2. See all sellers assigned to those territories

  3. Automatically filter the seller-level analysis to show only those matching sellers.

Essentially, I want the output of one filter to become the input for another filter across different datasets. the challenger here is: Territory id column does not exist in the Seller Analysis. The only shared column is seller id.

Please let me know if there is any way to do it.

Thanks,
Cindy

2

Hello Cindy,

May be please follow the below links, hope this helps in what you are looking for.

Thank you.

Cheers,

Deep

3

Hi @Cindy,

Following up here as it’s been awhile since we last heard from you on this thread. Did you have any additional questions or was the solution provided above helpful in your case?

If we do not hear back within the next 3 business days, I’ll mark the solution.

Thank you

4

Hi @Cindy,
Since we have not heard back, I’ll go ahead and mark the solution. However, if you have any additional questions, feel free to create a new post in the community!

Thank you

5

I have a similar problem - The links to the posts provided don’t seem to address the core issue - If I have a parent-child table: e.g. Customer table and Customer Reviews table and I have two datasets for each of these tables. A Customer can have multiple Customer Reviews so the two tables have a 1:M relationship. So if I were to write the SQL it would be:

from customer c JOIN customer_reviews cr on c.customer_id = cr.customer_id

The Customer Review Table has a Review Type field.

I have visuals in my sheet from both datasets. I want to add a filter/control to my sheet for Review Type, and I want the filter to apply to all visuals on the sheet across both datasets