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.