Forum Discussion
working with multiple table
Hi
I have 3 tables:
the id is the key: one to many on table 1 to table 2.
I created the relationship between all the table on the id key.
Each id column are suposed to be connected now however when I create the graph vizualization I don't see any connection. I mean if I put a slicer with id to chose and the id is from the table 1, then if I have graphes from table 2 and the id 1 has been selected there is no synchronisation since the id slicer is from table 1 and not table 2. How can I deal with this? Does the relationship help? or I need to do something else like combine ? I have to make graph on each table and to be able to monitor the id , thank you very much
Thanks
3 Replies
Anonymous , what output you want is not clear.
But you can join ID of table 1 to ID to Table 2 and Table 3
And analyse
So the relationship helps to make a new quierry with join?
The output should be graphs where I can see the how parameter from table 1 influence other parameters on table 2.
I tried to do this by adding a slicer where I can choose the id in the slicer and then to see the influence of ID on each graph. The problem is that the slicer is with the id from table 1. So the filter works on graph from table 1 but on graph from table 2 or 3 the slicer with id from table 1 does not filter anything.
The only way is to make a new quierry? or to combine maybe?
Hi Anonymous ,
What's the relationship between three tables? Is it like the screenshot below?
If so, the slicer on table1 will filter data in table2 and table3.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
