Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Relationship between tables help

Hello Community. I have multiple tables with this format, each from different facebook pages.   id likes_count created_time comments_count shares_count 134630197899_138554583939 1 2009-...
Need Help
Tips and Tricks
Tutorial Requests
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Anonymous,

     

    You need to add the like counts from other tables. Please check out a demo here.

    Relationship_between_tables_help

     

     

    Best Regards,

    Dale

shebr's avatar
shebr
Resolver III
8 years ago

Hi Anonymous

 

If you have multiple data sets similar to the one shown, what you want to do is the create a date table and point all your data sets to that date table and select the date from the date table as your axis. See below:

 

1. Watch the following video to create a date table in seconds! https://youtu.be/vJ7xNUK8sQE

2. Connect all your data sets to the date table in the relationships tab

3. Select date from the date table as the axis value

4. Select your 'like count' from different data sets. Perhaps create measures from them and name them differently.

 

Let me know how you get on.

 

Thanks

 

shebr

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks for the response. 

     

    I have created my Date table and have created the relationship between the tables. But it ends up looking like this:

     

    • v-jiascu-msft's avatar
      v-jiascu-msft
      Microsoft Employee
      8 years ago

      Hi Anonymous,

       

      You need to add the like counts from other tables. Please check out a demo here.

      Relationship_between_tables_help

       

       

      Best Regards,

      Dale