Did you get this sorted?
I have not seen a good solution yet. One current option that I have used is a creating a datetime parameter and setting it when I perform the action. This of course is not ideal.
1 of 1 people found this helpful
If you get your data from a Database, you can query the currenttime of the Database Server and then modify it in Tableau depending on the TimeZone you want to display.
***Example with mySql***
now() as 'UpdateTime'
Still not ideal because it adds an additional data source, another couple of clicks to update, and since it is a separate data source it would need to brought in as a secondary to show up in the worksheet title as an option, but I like your line of thinking here.
Since using an extract, this could be added to the custom SQL for the data source itself, adding another additional field. One benefit we get from this being a field is control over the formating of the date timestamp.
Thank you Michel!
I get the same error when I published it to our company server. Checked the settings in the machine as it is United kingdom. Do you know the exact setting?
Thanks a lot!
The same problem.
Is there any action we could take for this case?
My data refresh time was pointed to server time zone instead of our DB time
Any update on this problem? I'm having the same problem. The server is 5 hours ahead so my today's reports expire at 7 PM.
What I am doing is that I added one column in the source table/view to store the update time
Then I use this column in the front-end to display
This kind of column could be updated during your ETL process
Would it be possible to create a calculated field MAX(NOW())
and the a parameter data time and select maximum of the parameter and then insert this parameter into the title?
I am trying to do this on a story however I have yet to test it.
Has anyone figure this out? Our company server is in Germany so the "last updated time" shows 6 - 7 hrs ahead of us... really weird thing to explain to your users.
Almost 6 years (1 since the last post) and Tableau hasn't came up with a word?
We moved to Tableau Online and though this would fix but it didn't. My local time zone is EST but the "last updated time" shows +5 hrs difference
The response below by Chris McClellan may help with your query...
In addition the article below....
(note that for workbooks published to Tableau Online or Tableau Server, the Data Update Time will use the system time from the OS on the machine hosting the Tableau environment)
Hope this helps,
Thanks for your answer Ciara
I understand the problem is a local Time Zone vs Sever Time Zone. All answers in forums and tableau articles just tackle the issue with "workarounds" which, as you understand, are not ideal.
For instance, if I just modify my views to subtract 5 hrs from the reported updated time, how can I be sure Tableau Online server will always be 5 hrs ahead? How can I know where the server is located? (I'm sure Tableau Online manages several servers all across the world)? In my case seems to be in Europe, but how can I guarantee this is the case every single time I connect? Additionally, this would be a solution for MY time zone, but what about my users in other time zones? They will still see the wrong time. Furthermore, the workaround don't handle DST. Not all regions use the same DST changes, so even for my time zone, at some time of the year the reported time would still be wrong.
What is hard for me to understand is why Tableau can't handle this similarly to the way it handles it on the data sources list: