UTC to Eastern time zone adjustment
My question for the Domo Brillance Bar when arriving at the detroit user group:
We have a connection from 5/9s system to Domo with a timestamp column in the dataset. We created cards with this dataset and realized that the data was not reporting in the correct time zone. We added this dataset as in input in a dataflow and added a transform to convert the timestamp field to a date/time instead of text.
This is the code we added in our dataflow:
DATE_FORMAT(str_to_date(`TIMESTAMP`, '%a, %e %b %Y %T'),'%m/%d/%Y %k:%i:%s') AS ConvertedTimeStamp
Then we used the new field ConvertedTimeStamp in our cards to report the correct time zone for the calls that come in to our call center.
Any questions please feel free to reach out to me.