Hi GoodData team, I'm encountering an issue when trying to filter data within a visualization. Here's the situation: I have a

user

table and a

stats

table, with a one-to-many relationship—each user can have multiple stats. Users are connected to organizations through the

organisation_user

table, as the user-organization relationship is many-to-many. When I create a visualization using data from the

stats

and

user

tables, I can't seem to filter the results by organization. Could you help me figure out how to filter the results by organization so that each child workspace shows data specific to its organization?

Hi Haseeb, this is most likely related to how these tables are connected in the LDM, and what has been labeled a primary key. There are some good tips in the following article here: https://university.gooddata.com/tutorials/data-modeling/

Thanks @Joseph Heun, I'll look into it and let you know if i need any help.