Forum Discussion

Coo's avatar
Coo
New Member
3 years ago
Solved

Visual shows non-related data

I have 2 visuals that I want it to show correlated data when date is selected. It works perfectly when correlated records can be found in both tables. However, it appears to be table on the right wil...
Need Help
  • CoreyP's avatar
    CoreyP
    3 years ago

    I would recommend not using a many-many relationship unless you absolutely have to. Try creating a bridge table with unique values to join the two tables. Also add a date table so you follow proper star schema modeling practices. In the meantime, you could try changing the filter direction of both to single so that AllCalls filters the CCCAgent table. 

CoreyP's avatar
CoreyP
Icon for Solution Sage rankSolution Sage
3 years ago

Can you share a screenshot of your model view with relationships?

Coo's avatar
Coo
New Member
3 years ago

sure. Thanks for looking

 

  • CoreyP's avatar
    CoreyP
    Icon for Solution Sage rankSolution Sage
    3 years ago

    I would recommend not using a many-many relationship unless you absolutely have to. Try creating a bridge table with unique values to join the two tables. Also add a date table so you follow proper star schema modeling practices. In the meantime, you could try changing the filter direction of both to single so that AllCalls filters the CCCAgent table.