I've had to figure out a similar function to combine several date fields (up to twelve at a time) into the same timeline, and this is what I have come up with. If I understand your question well, this will work.
You want to combine the two timelines into one, so you'll need to create a cross table using the CROSSTABLE function in the script. Let's say your data is separated into the following fields:
I'm sure there are more fields, but for the sake of simplicity, we'll continue with this. To combine the two date fields, use this function in the load script:
OrderCreateDate AS [Order Created]
OrderFinishDate AS [Order Finished]
From [source reference]
That is the simple version. It will likely have to be edited to fit the data that you have, but you should be able to understand it well if you check out these videos:
I hope that helps! If it wasn't clear enough, let me know!
After some additional trial & error, probably based on my non-expert knowledge, the canonical date seems to do the trick.
I still have some weird behaviour in data visualisation, but will have to dig deeper to be able to find the issue there.
Thanks for your input, i'll mark this question as resolved.
Thank you guys for your reply.
I went on the 'drop autocalendar and start with master calendar' road.
However, i've got an issue in my loadscript, not sure if it's because of the field type in my database or my loadscript, but i'm getting an error in my master calendar script.
Will post that as a new question and get back to this as soon as i've been able to solve it (with the communities help )