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
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 106 SQL DataFlows
- 646 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 774 Beast Mode
- 75 App Studio
- 43 Variables
- 728 Automate
- 186 Apps
- 467 APIs & Domo Developer
- 61 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 403 Distribute
- 117 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 136 Manage
- 133 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 112 Community Announcements
- 4.8K Archive