You only have "Program" as shared field which can link the two data.
You can analyze at the level of Program, but can not at Project level.
You should have "Task ID in Source 1" or "project ID in source 2" to make consolidated analysis work.
Thanks. I can do this on the database side but was hoping I can do this in Tableau. No way to create a calculated value that looks for a task that falls within a projects start and end? For example, let's say Master Program 1 and Project 2 has a start date of 9/1 and end date of 9/4. A task under Master Program 1 has an execution date of 9/2.
There's no way to say since it matches the program to check all the start and end dates and find the one that fits?
The risk to use date is that if there are multiple relationships, it will be screwed up.
Unique key is needed to link the multiple datasource.