Filtering a set of rows by event time (across different time zones)
I have a dataset, for example, with 3 events in each of the US time zones -- all coming through as 7pm local to the time zone in the dataset.
I need to sort them by the time occurring, so in the example below, California events would be listed first, then Colorado, then Chicago, then New York.
How can i do this? Can I do it in a beast mode?
Event 1, California, 7PM
Event 2, California, 7PM
Event 3, California, 7PM
Event 4, New York, 7PM
Event 5, New York, 7PM
Event 6, New York, 7PM
Event 7, Colorado, 7PM
Event 8, Colorado, 7PM
Event 9, Colorado, 7PM
Event 10, Chicago, 7PM
Event 11, Chicago, 7PM
Event 12, Chicago, 7PM
Thanks!
Answers
-
Do you have the time zone as part of the datetime data? (i.e. EST, PST, CST, etc,) If so, you can build a case statement to put it in UTC time (or standardized to any time zone that you want). You can use the SUBTIME function to subtract the necessary hours. Here is a list of time zone abbreviations to be looking for.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
Domo expects data to be imported as UTC. Is it possible to import your data using UTC instead of the local time?
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 561 Beast Mode
- 8 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive