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.