I'm working on a dashboard that shows statistics for airports. The data is not organised by location, the airport, but rather by flights: from the Departure airport to the Arrival airport. However, I want to organise my dahsboard by a single airports (location), regardless whether a flight departs or arrives there.
Example: I want to see statistics on Security queues before boarding, but also on the queues of the Immigration gates after arriving, all at the very same airport, on one dashboard, using the airport manager's name as the filter.
I've got 2 data sources:
- the statistics
- the 'Airport Manager contact list'
Both data sources contain the same list of airport codes (dimension, string), between which I want to establish the relationship. The difficulty is: the statistics distinguish between 'Departure' and 'Arrival' airports, while the contacts list just contains the airport codes.
I want to filter my dashboard on names of the Airport Managers (dimension, string), but I can only establish one relationship between Airport Manager and either the Departure Airport or Arrival Airport (both dimension, string).
Duplicating could be an option, by duplicating the statistics data source and splitting between Departure Stats and Arrival Stats:
- establish a relationship between Manager and Dep airport (from Dep Stats data source)
- also establish one between Manager and Arrival airport (Arr Stats data source)
However, on doing this, my charts with the duplicate data source have gone blank. Also, my first data source (Dep Stats) kept showing a blue tickmark in the 'Data window', whilst only using data from the duplicate source (Arr Stats) and the airport managers (both orange).
I guess this becomes a complicated 'love triangle', as apparently I can't play cupid between the duplicate data source and the contact list, while having the also a relationship between the original data source and the contact list for the same dimension.
How can I best approach this?