Cards displaying today when set to yesterday - possible time zone setting issue
Our local time here is 6 hours behind UTC. We have a card that is set to display "yesterday" and it is a datetime column. I checked the card at 5:55 PM and it was displaying [yesterday's] data, then I checked it again at 6:01 PM and it was displaying [today's] data. So it seems like the "yesterday" in the card calendar section is based on UTC instead of our time.
In the domo admin section, our company setting is set to UTC. This is done with the assumption that Domo expects the data coming in to be in UTC, and since the data coming in is in our local time, we wouldn't want Domo to subtract 6 hours from the data coming in if we set our company setting to central. Does this sound correct?
My personal profile and the card creators personal profile are set to central/chicago
Does anyone have any thoughts on this?
Best Answers
-
Hi @Jbrorby ,
So the timezone in Admin is different from the timezone used to pull in data. Go ahead and change the admin timezone to central.
As for datasets, you can change that in scheduling and while the displayed default is in UTC, you'll see CST right next to it so I just put all my dataset updates in CST.
Made a video for you:
Let me know if that helps
John Le
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
0 -
To clarify, the company timezone is what the UI will display your timestamps with and will convert the values when the data is displayed. Domo assumes UTC for all data being imported.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
Hi @Jbrorby ,
So the timezone in Admin is different from the timezone used to pull in data. Go ahead and change the admin timezone to central.
As for datasets, you can change that in scheduling and while the displayed default is in UTC, you'll see CST right next to it so I just put all my dataset updates in CST.
Made a video for you:
Let me know if that helps
John Le
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
0 -
To clarify, the company timezone is what the UI will display your timestamps with and will convert the values when the data is displayed. Domo assumes UTC for all data being imported.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 811 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 80 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive