Use 2 different measure that have their own time in a single graph
Hi,
I've been searching for this answer for 2 days and I'm unable to accomplish anything.
I have multiple travel time data from different source for the same peace of road.
I just want to be able to put them all in a Line Chart graph to see every fluctuation of Travel Time in the same graph.
The problem is that I'm unable to find a way to bind them together because they don't have any unique key that represent a single time, every data have their own time measure.
I found this link : Canonical Date that might help but I don't know how to properly create all of those Calendar Table.
On the other hand I've found Calendar with time (timestamp) this link that have help me create a Calendar table with every second of a period, but when I link all of my other table by their time to the master Calendar the graphs show a flat line of data.
