I have a metric (dimensions Month and Employee) where I have the Country of an Employee by Month (for example : from Jan 22 To Jun 22 → France, From Jul 22 to Dec 22 → UK).
I have a Transaction with financial accounts with columns of Month and Employee ID.
I need to get the Country of the Employee in the Transaction, according to the Month.
How can I do that ?
Best answer by francoisView original