Forum Discussion

Coo's avatar
Coo
New Member
2 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
    2 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. 

Coo's avatar
Coo
New Member
2 years ago

Sorry No. What I mean is that the left table is showing data from Sep 1st but the table on the right is showing data from Sep 11th because that's earliest date the right table has data. If I pick Sep 11th as the date, then both tables will show correlated data.

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

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

  • Coo's avatar
    Coo
    New Member
    2 years ago

    sure. Thanks for looking

     

    • CoreyP's avatar
      CoreyP
      Icon for Solution Sage rankSolution Sage
      2 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.