This sounds like it should be working.
The primary data source is blue and the secondary data source is orange. Is Data Source 1 Blue and Data Source 2 Orange?
On your rows shelf does Activity ID have an Orange check mark on the left? It should not based on what would work.
A blend works similar to a left join where anything in the primary datasource is returned but only matches from secondary datasource are returned. I think you have the data sources mixed up or you have them correct and you used the wrong activity ID in the view. This would cause issues as the secondary datasource doesn't have the other activity ID so it would have no way of populating the other one.
Although they are blended the members of any field are entirely mutually independent of one another!
Check those few things and let me know.
Thanks for your reply Carl. Yes, the primary is blue and secondary is orange in my workbook.
So, when I disable the link between Activity ID and Fudning ID it returns every activity that exists in the source 1 (spreadsheet) but apparently it doesn't bring the correct metrics values.
Now, when I enable the relationship between the IDs then it brings the correct values of the metrics but only for activities for which there are actual metrics in source 2 (see below screenshot - it returns only one activity). For the rest funding IDs there are no metrics values against those IDs in the database at all and hence, it doesn't even return them in the list.
So what I'd like to do is a mix of these two cases. Bring everything from activities/funding IDs, even when there are no metrics against these in the database.
Hope it makes sense
1 of 1 people found this helpful
You have a filter from the blend. Can you move that filter onto the rows shelf jsut after activity id? It might be that these corresponding fields are filtered off from the secondary. Are there any other filters coming from the secondary data source?
Thank you very much for that. It wasn't the actual filter that is shown in the screenshot but another one which limited the results only for the year 2016. So in this case it didn't pick up the activities with empty metrics, because I had to select the "null" year together with 2016. Apparently, activities with non actual metrics in source 2 would fall under "Null" year, so that's why. So thank you very much for your help.
However, this brings another question for which I have already opened a thread. I'd much appreciate if you could give me your thoughts on that Custom Filter
Thank you very much for your help