filter a view on a field in joined table
Associated parent fields and grand parent fields can be included in filters now. Details can be found in the Filters Knowledge Base article.
Jake Marwil commented
Great suggestion! Being able to create a filter using fields from a parent table would certainly be a useful tool. Although we don't have a specific timeline yet, this is definitely a feature our product team is aware of and something we hope to implement soon. We will be sure to keep you posted with any updates. Let us know if you have any other suggestions!