Forum Discussion
Solved
Dates Field from Different Data Sources Not Separating
Hi, I am trying to bring in 2 different datasets, they are similar but have their differences. I am trying to create a bar chart showing the sum of "Happy Scores" against the date when the surve...
All sorted, needed to brush up on my Star Schema and create primary keys between the data tables. For anyone looking to work with data sets within the same dashboard, Ralph Kimballs Dimensional Modelling Techniques book is fantastic and goes through this topic comprehensively.
Thanks for everyones reply!
I think you should another date table contain all date from both tables. And make a relation from the date column in date table to date column in both tables. So, on the viz you use the date column in date table to axis field and two measures to values field on viz.
Hope this help.