I have a Report published on Tableau online which has hour based date time filter but since Tableau Online is in time zone UTC, when a date time filter is selected, the report reflects as per UTC timezone wherein I want it to reflect as per CST. Current Workaround: Subtracting 5 hours from the filter selected to get accurate time on filter. But I will have to change the logic wrt to Day Light Saving changes.
Current Partial Logic:
CASE [Time Range]
WHEN 'Current Date' THEN
IF datetime([order_date]) <= DATEADD('hour',-5,NOW())