my first attempt to blend 2 data sets was not successful (Sheet called 1st attempt - attached), because its appears the following message "Cannot blend the secondary data source because one or more fields use an unsupported aggregation". Someone in the Community told me the following:
"MAX isn't supported in all data sources. Check what you're using and change to something that works.
The quick solution will be to change both data sources to extracts, but that would depend on your situation."
That's why I made some changes by myself in mi workbook in order to don't use MAX and MIN (Sheet with changes called Final table)
Now I have another problem... I am trying to make a graph, but I need to Count just one time each ID or Student warehouse Entity Uid. The problem is that t I can't use COUNTD because my data is blended, and I don't want to extract the data. (See workbook attached - it is just a sample)
Checking on the web, I realise that COUNTD is not supported for blended data, so I was wondering what can I do in this case?
Reviewing my data, I was thinking that maybe works if I assign a number to each row per Student warehouse Entity Uid (I created a new column in excel, so you can understand my logic - column DW), then I can filter just all the 1 values in the graph... but I was trying to do this in Tableau without success (it is possible?)
I will appreciate your support to try to find a way to COUNTD my field Student warehouse Entity Uid for blended data.
Thanks in advance,
Note: The Excel and Tableau files are just a sample to understand my calculations - My screenshots are of the real report.