Hi,
So I am lost on this one. In total I have 3 data sources, 1 universe and 2 excel files.
The issue I am having is that in the universe I only got 1 connection per excel file and no connection between all 3 data sources.
Example:
Data source 1 Universe:
Date
Location
Salesperson
# Clients
Data source 2:
Location
Province
Data source 3:
Date
Salesperson
SalesValue
(this is a simplified example of the issue).
So I can merge the value of data source 1 with 2 based on location
And the value of data source 1 with 3 based on Date.
However, if i then want to use all 3 together I get stuck. For example if I put a filter on "Province" my data of Salesvalue is gone or shows the same value in every cell.
How can i get this to work so that all of these data sources work together?
Do I have to create a seperate dimension that sort of combines some of this information?