Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

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. 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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?

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      8 years ago

      Please share the file using google drive or onedrive, there is no way to share thru post.