Forum Discussion
My dynamic visual won't work (relations)
Hello,
I found my solution. I needed 2 things :- Create a bridging table to have unique type of accomodation keys to create a one to many relation.
- Make sure my city keys table was setted as well on one to many relation. I don't know why but it wasn't the case, so I recreated this file (file 2) and everything worked fine.
Thank you vanessafvg for your help
i have added in a bridging table
not sure if that is giving the desired result it might need some more work.
if it incorrect please provide an example of one test you can expect when correct
Thanks again for your time vanessafvg
It actually doesn't work : when I click a type on the top graphic, it doesn't change my bottom graphic.
But I think the solution of creating a "bridging table" is the one. I tried it on another project, but I created a "type of accomodation bridging table" instead of a city key one, and it seems to work.
The idea is :
File 1 is connected to file 2
File 3 is connected to file 2
File 1 is connected to file 3 but not directly, towards a file 4 "type of accomodation"
Exemple : New project
Do you confirm the method ?
Thanks !
what did you click on and what did you expect to change? when i did it i thought it changed. ideally the whole thing needs to be remodelled in my opinion
before clicking
after cllicking
When you click on one type of accomodation on the top graphic "camping" for instance, i would like the bottom graphic to be filtered, so i only see the yellow bar and not the other types