1 of 1 people found this helpful
It's not an error message, it's information...
Calculations based on blended fields will not work in isolation because they intrinsically need the other data source
If you want to share data on the server, consider uploading a blank workbook to be used as a template with all the calculated fields in and point your audience at that rather than getting them to connect to the Tableau server data source
Hope that helps,
Initially I was afraid it might affect some of the reports in my tableau workbook.
Back to your point that calculations on blended fields cannot work in isolation, I believe this is causing the error on my end as my workbook do not show up after connecting to the two data connections residing in the tableau server.
Currently, I have multiple workbooks and they are connecting to two separate views. Do you suggest that I should have only 1 view so that the calculations would work when I connect this data connection to the server?
Thanks for your help.
I think you should have your 2 data sources published to your server, complete with all calculations possible that do not rely on any blended fields.
Calculated fields that rely on blending will be workbook specific - you cannot publish these within the data connection itself, but instead one possibility would be to create a new workbook in Tableau Desktop, connect to your two data sources on your server, create your calculated fields that work across the blend in the workbook and then publish the WORKBOOK to the server (i.e. a blank workbook) and tell your users that they should download this template to do analysis, rather than opening Tableau from scratch and connecting to the datasources on the server.
Does that make sense?
Thanks for the input. I get where you're coming from but the trouble with your suggestion is to re-do all the calculations again. For this current workbook, we have spent weeks on it so it won't be easy to simply migrate over.
That said, I will try to explore further and see if there are any other alternatives.