Hi everyone, I'm trying to create a cascading filter setup where a "Brand" dropdown should only show brands that belong to a specific company.
My Setup: Query 1: "Filter - Brands by Company"
SELECT DISTINCT b.name as marca
FROM brand b INNER JOIN company_product_group cpg ON b."brandId" = cpg.id
WHERE b."deletedAt" IS NULL AND cpg."deletedAt" IS NULL
AND cpg."companyId" = {{companyid}}
Dashboard Filters: Filter 1: "Company ID" (Text type, variable: `companyid`) 2. Filter 2: "Brand" (Text/Category type, variable: `marca`) - Values from: "Filter - Brands by Company" query - Column: `marca`
When configuring Filter 2 (Brand), I only see these options: Where values should come from: From another model or question Custom list Model or question to supply the values: Filter - Brands by Company Column to supply the values: marca
I don't see any option to map the `{{companyid}}` parameter from my source query to the "Company ID" dashboard filter
How do I connect/map the `{{companyid}}` parameter from the source query to the "Company ID" filter?
Should there be a "Map variables" or "Filter this filter" option that I'm not seeing?
Am I missing a step in the configuration?
Any help would be appreciated! Thanks!
What you’re looking for are linked filters. There are requirements for the table metadata to allow Metabase to infer the relationship between the tables so the filters work as expected. The feature is described here: