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.
CoreyP
Solution Sage
Solution SageBy "unrelated data" do you mean the blank row in the unavailable code column in the right table?
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.
