Making a local copy of the Tableau Server data sources seems to alleviate the problem above, but some of my calculated fields now calculate to this value:
I am mystified, and kind of in a jam, because I made this view for some people using tableau server data sources, lots of data blending including in calculated fields, and then table calculations on those, and it's starting to look like it'll be a nightmare to maintain.
I'm getting this same issue and not sure how to manage the problem of gigantic data sources that I don't want to duplicate, but the need to have copies in order to facilitate inter-data source calculations (the entire reason for having duplicate data sources).
The thing I'm finding most frustrating, though, is the lack of documentation around what exactly are the limits and capabilities of published data sources.
Did you discover anything?
2 of 2 people found this helpful
Just had the same issue and was able to solve it by creating new calculated fields with exactly the same script. (i.e. just cut and paste from the old calculated fields to the new, and then rename).
They then aggregated correctly!
I have found that regenerating or refreshing the extract can fix the issue.