Forum Discussion

adityavighne's avatar
adityavighne
Continued Contributor
7 years ago

How to Create relationship?

Hi,

 

I have data like below in 3 different sheets.

 

Twitter 

Date Twitter PageLike 
1/1/2017Asia1
2/1/2017India2
3/1/2017China3

 

Facebook

Date Facebook PageLike 
1/1/2017Asia1
2/1/2017India2
3/1/2017China3

 

Combine sheet

Date Total Like 
1/1/20172
2/1/20174
3/1/20176

 

I want to create a relationship between Twitter -> to -> Combine sheet and same with Facebook -> to -> Combine sheet 

 

Can I create somehow? Is there any way to do this.

 

Kindly Help on this.

 

Regards,

Aditya 

Need Help

2 Replies

  • TeigeGao's avatar
    TeigeGao
    Solution Sage
    7 years ago

    HI adityavighne ,

    In your scenario, you can create relationship between the Date column in Twitter table and Date column in Combine sheet, between Date column in Facebook table and Date column in Combine sheet, use the many-to-one relationship.

    Best Regards,

    Teige

    • adityavighne's avatar
      adityavighne
      Continued Contributor
      7 years ago

      This will not help.

      I have already had a relation  between dates.

       

      so when I select Date it gives me total likes not to drill down 

       

      Can someone help with this?