Community Forums

Discover best practices and find answers to your questions with advice from fellow Domo users.

Recent Discussions

Make Dynamic Date/Time Functions Respond to the Company Time Zone
The dynamic date and time functions—such as CURRENT_DATE() and NOW()—are represented in UTC, regardless of the Company Time Zone in your Admin Settings. This creates a problem during the hours of the day when the UTC date and your company time zone's dates are unaligned. For instance, say you have a Beast Mode that uses…
Strange datetime behavior when using the Five9 Domo Connector
I am using the Domo Five9 connector to pull a report containing list data into Domo and am encountering challenges relating to datetime fields. The two fields I am having issues with are: Timestamp - This field tracks the date and time that a given record was added to a list. created_date_string - This field within Five9…
Views keeps converting time to UTC
Hi All, I am having an issue with a dataset. I am trying to extract an hourly occupancy from people's entry and exit dates and time. However, Views keeps converting the times from Eastern to UTC. I have checked, and my company's time zone is already set to Eastern. I'm not sure what to do from here. If I do an offset in a…
Dataset Scheduler - Timezone list limit and/or alphabetic sort
As a new customer setting up datasets, the time zone selector is just a poor UX. First off, the time zones aren't sorted any logical way. It would be nice if they were at least alphabetic. Type to search would be helpful. But my primary "idea" is to add functionality at the Admin level to limit the time zone selectors to a…
Beastmode Timediff Errors
Hi all, using the following to calculate time differences between requested and actual drop off times: TIME_TO_SEC(TIMEDIFF(Actual Drop-off Time,Requested Drop-off Time)) / 60 Seems like the math isn't panning out (first column should be ~25 in the time difference column but instead is showing 1415.80). Haven't used the…
How can I keep my data's time zone consistent? 24 to 12 hour conversion issue.
A colleague of my is uploading data currently in 24 hour time into workbench. But, DOMO unnecessarily converts it from UTC to EST when he tries to change it to 12 hour time. Is there a way for us to stop it from adjusting time that's already in the right time zone? Thanks! 🙇
Period over Period with Non-Time X Axis
First time poster!! Thanks for all the help you've contributed thus far Domo Community. I'm trying to create a year over year comparison graph with our locations on the X Axis, instead of the required time period on the x axis. The period over period comparisons are only available when Time is used on the x axis, so I…
sec_to_time() Is adding an unnecessary period to durations
I'm using sec_to_time(`SessionTime`) to convert an integer of seconds into a duration however when a SessionTime should end in a single digit amount of seconds say, 5 seconds "12:45:05" the beastmode field is displayed as "12:45:5." This creates an unnecessary period and shows an inconsistent format. The result should show…
is there anyway to change default time in Domo?
Seems like date/time format always defaults to 12:00am. Is there anyway I can change this universally so that it always just defaults to 11:59pm when no time is specified in date/time format?
Calculating Time Diff (in hours) over Multiple Days
Hello 😊 I am trying to write a beast mode that will calculate the time difference in hours (sometimes over a multiple day period). For instance, if the start time is 4/1/24 at 1:00pm and the end time is 4/2/24 at 9:30am I would like the beast mode to calculate 20.5 hours. Any help is appreciated! Thanks!

Welcome!

It looks like you're new here. Members get access to exclusive content, events and more. Sign in or register to get started.