1 Reply Latest reply on Apr 5, 2018 4:27 AM by Łukasz Majewski

    Time Zone Conversion Calculation

    Manuel Munoz Jr

      I have a dataset that collects downtime minutes of internet service by an internet provider. This provider is on the U.S. East coast EST and has customers in England, India and Hong Kong.

       

      I need to create some type of filter or parameter in Tableau that allows the user after filtering for their Country, the ability to determine if the downtime event happened before or after their business hours, for example, between 08:00 AM and 17:00 PM in the customer's time zone.

       

      Additional facts/suggestions:

       

      • I am using an MS Access database
      • Perhaps I could store the UTC time offset in the Country Table of MS Access
      • I am getting the downtime values from an SQL connection.

       

      Please provide as much guidance as possible including sample code. I am new to Tableau and could use all the help I can get. :-)

      Thank you for your help!