-
Option to schedule datasets in UTC or local time
When we schedule datasets today, Domo schedules them in UTC, so there are no adjustments for Daylight Savings changes. This means that we need to reschedule datasets that must refresh at a specific time of day locally (i.e., 6 AM Central Time, regardless of whether we are in Standard or Daylight Savings time) twice a year…
-
Previous Month Last Year
I'm trying to make some companion comparison cards so that I can display, for example, on one card the top 10 PDFs downloaded last month this year versus another card with the same month last year. I have the data by month already, and I need to have this for each month, moving forward. Is there an easy way to set some…
-
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!
-
WEEKOFYEAR is not aligning to ISO-8601, is this correct?
Hi, I recently utilised the Week of Year function for a date column. I'm unsure if this is incrementing from 0, but the value for the 12th of Feb 2024 returns 6. I would expect it to return 7. . Can someone confirm if this is intended? It looks to use Sunday as the start of the week in this function. Best, Sam
-
Configuring Card for Last Time Federated Dataset Refreshed Based on Browser Time Zone
Hello, I am trying to visualize in a card when the last time a federated dataset has been refreshed based on the timezone that a person's browser is set to. For example, if I see that this dataset last updated at 2 PM and I am in the Eastern Timezone, I would want that a person in LA time see that the dataset last updated…
-
Different time zone
Hi! I'm trying to configure the time zone in ETL but my query is resulting in different times when the function calculates the difference, for the same column. ETL time zone function: Imported table from SQL Server: Result after time zone changes: The date range of the table is from Feb 24 to Mar 12. From Feb 24 to Mar 8…
-
Using Dremio Iceberg tables and time travel feature in Domo?
Hello everybody, Is it possible to create a dashboard that utilice iceberg tables from Dremio to perform time travel? Looking for something similar to this: Thank you in advance!
-
Need an option in our domo instance to have user specific timezone.
We need an option in our domo instance to have user specific time-zone. If a user is in EST time zone, he/she could see have an option to view the date according to their time-zone rather than a universal time zone. Example: Run time of any dataset is 9PM IST but someone from EST time-zone could view the dataset run at…
-
TimeZone selection in connector set up
We are using the ServiceNow connector. Our Company time zone setting is on ET. When I compare data record time stamps within ServiceNow compared to Domo, Dome displays date information 5 hours behind the actual time shown in ServiceNow. While we can convert the date/time to correct within beast modes and dataflows, it…
-
Custom Date & Timestamp Formatting in Analyzer View of Cards
Hello Domo users! As a relative newcomer to this fantastic platform, I am thrilled to share my first discussion post with the greater Domo Community. I've been working with Domo for nearly a year at this point, and it has been a wonderful experience and I truly admire the insightful analytics and operational abilities this…
-
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…
-
Average RunTime & API Versioning
Average Runtime: It would be great to have an estimated runtime for each connection in DOMO. When using a new connector, it is hard to verify how long it would take for a sample data set to come back before expanding to the time frame required. Versioning: Most APIs have a version number. It would be great when selecting a…
-
Way to sort by hidden field
Is there a way to sort a table by a field that isn't in the table columns? I'm trying to sort time information chronologically like this: 1:00 AM 2:00 AM … 12:00 PM 1:00 PM But Domo sorts it like this: 1:00 AM 1:00 PM 2:00 AM 2:00 PM etc. I can have the time displayed as 24-hour but I'd rather not if possible.
-
How is Timezone inherited from source then converted?
I have a dataset coming in from the Gong connector and some timestamps come in as text fields (scheduled, started). Our Domo timezone is set to Eastern. When I cast data type as timestamp, the times move up 3 hours. Should I assume the Gong source data is Pacific (Gong is in SF) and Domo is inheriting the timezone…
-
Average of a difference in Timestamps
I have two timestamp fields: completed at and delivered at. I want to find the difference of both and take the average. The dates include a window that is sometimes over a day. I read this By @GrantSmith which is useful. Is there an easy way to do this without breaking up each segment (day, hour, minute, second) then…
-
Creating an Artificial downtime for maintenance for only week and work hours
I am trying to calculate downtime within DOMO. The downtime we have currenlty coming from the other system does not put in the factors of weekends and holidays as well as after hours. How can I calculate a correct amount of time between the starttime to endtime while only subtracting within the window. For example if A…
-
Is the KB article for Time Zone not yet updated?
This is regarding support case where customer is requesting to add Mountain Time Zone. The customer was unable to find required time zone as the drop down does not contain all time zone. One needs to manually enter the name of the time zone to get related time zone, which customers are not aware of. I am sharing the KB…
-
Period over Period Visual, YTD, 2 Day Delay with Current Date Data
Hi all, I'm leveraging the period over period charts and comparing the year to date progress with the progress from a year ago. Unfortunately, there's a two day delay in when the data comes in, and the historical period data isn't reacting to that. Is there a way to address that while still using the period over period…
-
Creating a Heat Map Based on Start and End Times
I have a data source that includes one row each for scheduled activities, with a column with the start date/time and end date/time (i.e. 2022-09-06T09:00:00 and 2022-09-06T13:00:00). What I need to produce is a heat map showing blocked out times in hour or half hour increments on a heat map, with the days of the week as…
-
Heatmap in 30 Minute Intervals
I've created a heatmap based on the timestamp of records with the day of week on the Category 1 axis and the hour of day on the Category 2 axis. However, the business is asking for a version that breaks things down into 30 minute intervals. I'm currently using the HOUR function on the timestamp to extract the hour, but I'm…
-
Version history for notebooks
I was a foolish person and didn't realize that I was editing a different notebook than I intended to. As a result, I lost a couple hours' worth of work and get to rework a problem that was pretty well settled. Obviously the first/best solution would be for me to not be foolish. Barring that possibility, having the ability…
-
How do I sort my time of day ranges on a card so it is in chronological order?
I created a time of day beast mode below which works successfully. I am using a bubble chart to show the time od day most events occur. This also works successfully however, I would like to be able to sport my time of day in chronological order. I have tried to use the beast mode created below in the sort as both assending…
-
Dashboard & Card Date Range Filter Reflecting Local Time
I would like the option to configure the Date Filter on dashboards and cards to reflect local time without having to change the company time zone setting. The goal is for options like 'Today' in the dashboard or card filter to reflect the device's local time without all of the additional effects of changing the company…
-
Help With Beast Mode Calculation
I have a dataset that has the following Fields Agent Name - Name of the agent Agent Status= This is the state the agent was changed to . Available, Unavailable, Idle etc. EventTime = Equals the timestamp that the agent status changed to I need to calculate the time the agent was in that state, for example, Agent changed…
-
Trimming and converting a Date/Time Field
My goal is to filter all times between the hours of 9PM-5AM, but the data in my field looks like this: 2021-12-31T21:20:49 How would I trim this field to get the time exclusively and possibly convert it to 12-hour format? Thank you for your help