Context: We have a report that uses a SQL Model as data source. In this data source, we have many columns, and one is the Organizations ID. Our system has many organizations (each organization > different client).
We added a new column to this report, which is Resident Type. But Resident Type does not have a fixed value for all customers: each organization can create their own Resident Types. So while Org A has “Resident” and “Non-Resident” as their resident types, Org B has "Homeowner” and “Renter”.
The problem: We want to add a “Resident Type” filter in this report as a dropdown, and displaying only the values applicable for the logged organization, connecting the Resident Type filter with the Organization filter by using Linked Filters/Field Filters. However, we weren’t able to do that.
Images for more context:
In Resident Type Filter > Dropdownlist > Edit, we created a question as data source following Field Filters video:
But when trying to connect the Resident Type filter with Organization filter, it says we need to use Field Filter (but as the image above shows, the data source for this filter is already a Field Filter!)
In Linked filter documentation, it says it will only work with “two different tables that have a foreign key relationship specified in the table metadata”, and this is already configured before we created the filter:
