Forum Discussion
Managing Relationships
ricardocamargos I have not. I'm not exactly sure what that is. Would like to find out!
Anonymous as you already create a calculated table with distinct value, I assume at that point you are able to connect both the tables with this new calculated table? Are you having trouble setting relationship? What problem we are solving here?
parry2k yes, that is my exact issue. Even though I've created a table of distinct co values from 'CService', I still cannot create a table or any other visualization that has fields from 'CService' and fields from 'EMS Survey'. It only understands the relationship between 'Cservice'<->'Distinct Co' and 'EMS Survey'<->'Distinct Co' and I'm trying to get to a point where I have 'CService'<->'EMS Survey' so I can use the necessary fields from each. I thought my calcuated table of the distinct co values would bridge the gap between these two datatsets.
Can you share the sample dataset? I don't see any challenge once relationship are created. My assumption is at this point your both tables are connected to this distinct table you created, make sure your relatonship cross filter direction is set to both, which you can check on relationship dialog box.
If you take a simple table visual, drop fields from both these two fields, I expect you will get correct result.
parry2k Yes I can share a sample dataset. I've been asked to do this before, but I've never done so yet. How do I share with you?