Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Can't display the visual

Hi All, Getting the famous error. I have about 20 data sources in my report. All of them are connected in the relationship module. Some sources have a single connection, some have 2 connections. ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI Anonymous,

 

I think you need to add a bridge table to extract id value from these tables, then use bridge table to link tables which you mentioned.

 

After above steps, you can use bridge table id and other fields to build a visual.

 

In addition, please share some detail information to help use clarity your scenario.(e.g, data structure, relationship, fields which visual used)

How to Get Your Question Answered Quickly

 

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi,

    These are the "bridge tables".

    For example Table2 is the bridge between 1 and 3.

    Also there are bridges between all tables in my schema.

     

    So if table 1 is salesmen, and table 3 is sales, table 2 will have salesmen ID and sales ID.

    In that way I can relate all sales made to a specific person.

     

    About the data,

    It is hard for me to provide it, as I am working with sensetive data. Creating dummy data requires a lot of effort, which currently I do not have the capacity for.

    Also, I have about 20 tables in my relationship, and reconstructing with fake data, not always works.

     

    I am asking about possible issues and how to investigate. 

    Not asking for the resulotion.

     

    Ta!