Forum Discussion

ricardocamargos's avatar
ricardocamargos
Continued Contributor
8 years ago

Hi Anonymous,

 

Have you tried to create a dimension to those fields which both tables have in common ?

 

Ricardo

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    ricardocamargos I have not. I'm not exactly sure what that is. Would like to find out!

    • parry2k's avatar
      parry2k
      Super User
      8 years ago

      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?

      • 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.