Forum Discussion

H_Jones's avatar
H_Jones
Helper I
8 years ago
Solved

Relationship removing data from report

Hey, I have created a relationship between a results table and a targets table but if there isnt results for all of the channels I have targets for, the target shown is only the total target for the ...
  • H_Jones's avatar
    H_Jones
    8 years ago

    Sorry after some digging around I realised there was an error with one of the relationships.

     

    Thanks!

     

    H

mehaboob557's avatar
mehaboob557
Resolver III
8 years ago

Hi H_Jones,

 

Please let me know is my understanding is right or not

 

you have results and target tables and i hope channels is the primary key.

 

you are having one-one relationship?

 

and what filters you are using?

 

 

H_Jones's avatar
H_Jones
Helper I
8 years ago

So it is a one - many as the results table is a line per transaction and Channel is the Primary Key/used to create the relationship.

 

No filter used for the visual.

  • mehaboob557's avatar
    mehaboob557
    Resolver III
    8 years ago

    Hi,

     

    Please check sample file here

    • H_Jones's avatar
      H_Jones
      Helper I
      8 years ago

      Sorry after some digging around I realised there was an error with one of the relationships.

       

      Thanks!

       

      H