Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
Hi @Anonymous,
You need to add the like counts from other tables. Please check out a demo here.
Best Regards,
Dale
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
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:
Hi @Anonymous,
You need to add the like counts from other tables. Please check out a demo here.
Best Regards,
Dale
User | Count |
---|---|
102 | |
91 | |
87 | |
79 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |