I've recently experienced something similar with several of my calculated fields being converted auto-magically to a measure named "Calculation_xxxxx" which of course does not exist in my source tables and breaks my extracts on these worksheets. Any ideas?
This happens because Tableau holds information about a connection in two places: the workbook itself (the .twb file) and the extract (.tde). There are various scenarios which can cause the state of the connection as represented in those two files to get out of step. The "Calculation_nnnnnnnnnnnnnnn" field represents a calculated field for which the results of the calculation have been stored in the extract, but for which the original calculated field definition is not present in the workbook. (Tableau stores calculated field results in the extract for efficiency reasons - it means the calculation does not need to be evaluated each time it is referenced.)
The sort of scenario that can cause this is as follows:
1) Add a calculated field to the workbook.
2) Do some operation that causes an extract to be created or updated (for example create a new extract or optimise an existing one.)
3) Exit Tableau without saving changes to the workbook (either by explicitly saying no to the "do you want to save changes" question or because Tableau crashes.
Next time you open the workbook, Tableau spots the "materialised" calculated field in the extract, but doesn't have the associated calculation in the workbook, so gets confused.
In my view the window of opportunity for this sort of issue would be reduced significantly if Tableau automatically forced a save of the workbook whenever any operation which changes relevant state in the extract was updated. It might well need to warn that this was going to happen. I vaguely recall noticing that some changes might have happened in that space a while back, but it seems there are still opportunities for it to happen.
Fixing it up when it has happened can be really difficult. The most reliable way ways are either to go back to a backup of the workbook before the problem happened or to remove (and delete the extract), delete any remaining "Calculation_nnnnnnnnnnnnnn" fields and create a new extract. It's a long time since I hit the issue, though, so I can't remember if there are other twists here, maybe someone else who has dealt with it more recently has some ideas.
Refreshing the extract worked for me on 10.0.1.
This is such a shitty bug. Glad not many people run into it. Maybe it's mac only. Sometimes I can get it to fix itself by removing the extract file on my computer, changing to a live connection, and then back to an extract, but sometimes not. I can't simply redo the connection either when I have 20+ calculated fields.