Forum Discussion

raymond's avatar
raymond
Post Patron
7 years ago

Data Model Cross-Filtering between 2+ Tables

Hello everyone,   I guess it is a seemingly simple problem but I dont know how to do it. There are 3 tables that I want to cross-filter. At the end I want to set a filter on which I can select e.g....
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

You should be able to keep just the three source tables, and then make a relation from the channel table to the other two tables. And that is more or less it, if this solves the problem mark it as solved.

raymond's avatar
raymond
Post Patron
7 years ago

Thanks for your help. Unfortunately it doesnt resolve the isse.

1. There is a warning due to the many to many relationship which I would like to avoid.

2. When I filter by Channel (e.g. Google_1) the associated clicks and events dont get filtered automatically and vice versa.

 

I was thinking of including matching tables but this doesnt work right as well. It does however show me the right values when I start from the channel table. The further I go, the more inconclusive the values gonne get. The Content table only shows two columns correct. The Conversion table only shows conversions correct.