so I have the following problem:
Lets say I sell products in the US and EU and would like to analyse my sales. I've got my EU and US info in different tables.
It looks something like this:
Now I would like to analyse my data on a common timeframe. For example I'd like to see my overall sales (US+EU) trend in a Line chart. So somehow i need a common Timedimension/calendar out of my data. Any clues on how I get that?
I have read this article: Canonical Date, but I'm not sure I understood that correctly, plus its about qlikview.
Thanks in advance!