I know how to create a segment that uses an association filter when the table I am creating a segment for has a foreign key to the associated table. However, is there also a way to segment on an associated table value when it is the associated table that has the foreign key?
For example, I want to create a segment of all companies that have a subscription with a status of 1. Subscriptions has the company_id foreign key. Even though the metadata builder lets you set the other side of a foreign key association, those associations don’t seem to be visible in the filters popup.