i should add that it appears to not be a graphing issue per se - i also use the calculated field GOAL Graph in a tool tip and the same behavior occurs there as well: after extract refresh GOAL Graph in tool tip returns raw GOAL DB number until i manual touch GOAL Graph, which seems to force tableau to run thru the calculation.
thanks for any help
I see you never got an answer, were you able to solve this issue?
I am having a similar issue. I have a calculated field with the function "TODAY()" and a second one with the function "NOW()". Both have their own parameter using a list that I have populated using the "Add from Field" button so that the parameter always has the result of the calculated field. I then use the parameter in my where clause in my custom SQL so that I always pull data between the current date at 12:00am to the most current time on that day (i.e. 9:00pm). My problem is, even when I refresh the extract the calculated fields still show the old timestamps from when I set them up. The only way to fix this I found is to recreate the parameters and then preform the extract again.
How am I supposed to get the query to return the current day's worth of data without having to recreate parameters? Most of the users will be viewing this report on the Tableau server and I would hate to have to instruct them on creating the parameters and performing an extract refresh every time they want to view the report.
I had the similar issue. I had a calculated field converting a field from UPPER CASE to lower case. I had the live connection to the database at first, and the calculated field works fine. When I extracted the data, the calculated filed start to look odd(I have the CF as a filter as well). The UPPER CASE are still UPPER CASE(except one value). I find it very odd.
I think it's a Tableau bug. I modified my calculated filed(same logic!!!) and it looked.
It is sad that four years later this bug has not been squashed. I have calculated field with the following code.
DATETIME(INT(FLOAT([MX Out Local Date Time])*(1440 / 15)) / (1440 / 15))
It works great until I refresh the extract. All I need to do is add/subtract a space anywhere in the code and it works well. This is very frustrating because it keeps me from being able to use an auto-refresh and/or a published data source.
Has anyone found a true solution to this issue?