2 Replies Latest reply on May 14, 2018 9:26 PM by Scott Schmeling

    Adjust time based on location

    Scott Schmeling

      Hi,

       

      I'm building a dashboard and was wondering if there is a way to set the time based on location selected in a filter.

       

      I was able to add a calculation like this:

       

      Case [City]
          When 'Los Angeles' then Now()
          When 'San Diego' Then Now()
          When 'San Jose' Then Now()
          When 'Phoenix' Then Now()
          When 'New York City' Then Dateadd('hour',3, now())
          When 'Philadelphia' Then Dateadd('hour',3,now())
          When 'Chicago' Then Dateadd('hour',2,now())
          When 'Houston' Then Dateadd('hour',2,now())
          When 'San Antonio' Then Dateadd('hour',2,now())
          When 'Dallas' Then Dateadd('hour',2,now())
      END
      

       

      However I would like to know if Tableau has a function that can do this automatically- show time based on location selected. 

       

      Thanks,