I am not sure if I got your question right.. but I am guessing you want your report to show the current time period data and should take the time when user is accessing the report.
That can be done through the calculated column as you can use 'NOW()' function to get the current time from tableau server and then you can adjust that calculation for time difference to get correct EST time. now use this calculated field as a filter in report to show only this time period.
Super, thaks Pulkit. That sounds like what I need. I'll have a try and see if I can get it working, thank-you.
What I've just seen however from the NOW spec NOW() Function Returns UTC Time | Tableau Software is that it is indeed UTC time returned. Eastern Standard time at the moment is 4 hours behind UTC time. But how would I eloquently manage the calculation for daylight savings? All I can think of is in the calculation incorporating the date daylight savings kicks in for EST. However, I am sure that I am not the first person to come across this scenario.
Does anyone have a better idea on how to get EST (incorporating day light saving) from the Tableau Server?
In Tableau there is no automatic calculation to adjust daylight savings/timezones you have to do a manual calculation only
Though you can easily find the calculation already created easily over the net.