Forum Discussion
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...
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.
sure. Thanks for looking
CoreyP
Solution Sage
Solution SageI 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.