Forum Discussion
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-09-23T17:23:52+0000 | 3 | 0 |
| 134630197899_134634977899 | 6 | 2010-02-09T21:13:29+0000 | 3 | 0 |
| 134630197899_292605132899 | 10 | 2010-02-09T21:34:23+0000 | 2 | 0 |
| 134630197899_308390749110 | 8 | 2010-02-15T19:51:40+0000 | 1 | 0 |
| 134630197899_317460852899 | 1 | 2010-02-22T20:53:49+0000 | 0 | 1 |
| 134630197899_324417852265 | 0 | 2010-02-24T13:47:37+0000 | 0 | 0 |
| 134630197899_341595679168 | 12 | 2010-02-26T14:14:39+0000 | 4 | 0 |
| 134630197899_351862283576 | 2 | 2010-03-04T22:10:02+0000 | 2 | 0 |
| 134630197899_10150117250320104 | 1 | 2010-03-05T13:39:08+0000 | 0 | 0 |
I want to make a report with the "date" as the X axis and the "likes count" as the Y axis but I wish to have multiple bars with different "likes count" from different tables so I can show the comparisson between them.
I have tried to make a relationship "1 to Many" from the id column in a table to the "created time" column in another table but when I do this the report can no longer use the Date Hierarchy which makes the report really messy.
Help please
Hi Anonymous,
You need to add the like counts from other tables. Please check out a demo here.
Best Regards,
Dale
3 Replies
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
Hi Anonymous,
You need to add the like counts from other tables. Please check out a demo here.
Best Regards,
Dale
