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 channels with results, for example:

 

If I have results table which ends up looking like:

 

ChannelTrasactions
Email1000
Mail1000
SMS1000

 

And a targets table which is:

ChannelTargets
Email1100
Mail1000
SMS1100
Phone500

 

And they have a relationship on Channel (bare in mind the results table will actually be per transaction), then when I make a Guage for results and targets the target shown will only be 3200 i.e. doesn't include Phone as there want any results, can anyone find a way around this as its not showing true values.

 

Thanks,

Harriet.

  • 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

6 Replies

    • H_Jones's avatar
      H_Jones
      Helper I
      8 years ago

      Hey mehaboob557 I cant quickly share it as I would need to make a completely new fake datafile instead of using the organisational data, Is there any ideas just considering the what i have explained?

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