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
You're only one dashboard away.
Click here for more video solutions:
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
You're only one dashboard away.
Click here for more video solutions:
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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive