Most definitely. You can link as many fields as you need to for the calculations to work properly - that might be 1 field or many it just depends on your data.
That is a very open-ended question, Jon. There is no single answer to it. What you do to blend data sources is completely dependent on the results you are trying to achieve.
When creating a blend, Tableau automatically matches based on the column name. If you have lots of matching column names between 2 data sources, Tableau will create a link for every match it finds. That is rarely (never?) the right thing to do. Usually, I get rid of ALL the automatic links and create only the ones I need.
Without seeing your data and without understanding precisely what you think is incorrect about the current data, it's not possible to be more specific.
what determines why you would add more linking fields...
"if your calculations uses fields from secondary data source you must link the field" is there any rhyme or reason?
my data is linked by fields in filter shelf.... why link to other fields, what drives that decision?
Now we're getting into relational theory!
If you have 2 independent data sources, you can DISPLAY data from one data source at a time, and you can't put data from the OTHER data source on the same worksheet as the FIRST data source, because there is no connection between the 2 sets of data.
We link (BLEND) 2 data sources so that we can put data from BOTH data sources in the same worksheet. Often, it's something as simple as getting the SUM() of Invoice Amount from one data source, for each customer (from a different data source). All we need to do that is to link on ONE field shared between the two data sources (in this case, perhaps that's Customer Number).
In cases where there are a LOT of common fields between data sources, it's up to YOU to determine what the logical connection between the data sources should be, for the result you are trying to obtain. Again, it is VERY hard to give you any specific advice here, because we don't know what your data looks like.
"if your calculations uses fields from secondary data source you must link the field" is there any rhyme or reason? - YES, there is. It is critical to get your Blend fields set up correctly or you WILL get bad results. But exactly what you need to blend on is completely dependent on what your data looks like and what you're trying to do.
my data is linked by fields in filter shelf.... why link to other fields, what drives that decision? I don't know what that means, Jon. Do you mean you put a field in the Filter shelf that also has a Link icon next to it in the Dimensions or Measures pane?
very nice of you go to in details Mike.
your right, trying to troubleshoot a specific problem based on my data is difficult, ill continue to do my own research and see what i can find for my specific situation. thanks for the try
Happy to try, at least!
Good luck, and keep asking questions.