if joins can be used to combine multiple data sources using the 'Add' button on the data source page of tableau.?
Yes with ADD Connection you can join the tables from different data sources which is called cross data base join feature in Tableau
I found some calculations were not working with the new dataset that i joined, but started working as soon as i changed the connection from live to extract? What is going on here?
Your database doesn't support some of the calculations when you tried to create a extract which means you are converting live data tableau extracted data which is stored in RAM and its tableau compatibility data source that's why you are seeing the calculations work after extracting the data
Hope this helps
Plz mark this answer as correct or helpful to close the thread
The database does support the calcs but it doesn't allow cross calculations