-
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…
-
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…
-
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
-
Forecast monthly expense
I'm trying to create a formula within ETL that will help budget owners understand how their expenses will be accrued over time. Ex: There's one Purchase Order that has $10,000 left to invoice, and the PO end date is July 31,2022. Our accounting team would expense them evenly for $2,500 for April - July. So I'd need to…
-
Convert Timestamp to CST, UST, MST, EST Python
I have a data set like the following: start_time_UTC 2021-09-16T12:00:00-05:00 2021-09-15T19:00:00-05:00 2021-09-16T08:18:00-05:00 2021-09-16T12:22:10-05:00 My default time is UTC, but I would like to create multiple columns based of the start_time_UTC to create cst, mst, and est. from domomagic import * from datetime…
-
Add Time to Datetime
I have two columns `timePlaced` is a datetime, while `timeEstimate` is an integer that represents minuets. Using the below beast mode I am able to convert `timeEstimate` to minuets, ex 10 turns to 00:10:00. SEC_TO_TIME(`timeEstimate`*60) When I try to add it to `timePlaced` using the fowling beast mode I get null values.…
-
Adobe Analytics OAuth 1.4 connector - Update a dataset hourly
-
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…
-
Timestamp Convention in JSON File from Command Line DataFlow Request
My question: Does anyone know DOMO's timestamp convention and how these map to normal timing conventions? Background: I am using DOMO's command line tool to get JSON structured metadata about a DataFlow. Specifically, I am using the list-dataflow command: Putting in the DataFlow id and a filepath returns a json file to…
-
Timezone Conversion in ETL
Since most datasets are brought in at UTC time, there should be an option in the ETL to convert date/time timezones so that I can then have a proper date/time to date conversion to throw in a group by. Currently, the date/time to date will result in a UTC date which isn't helpful at all. I could add hours to the date/time,…
-
Allow Graph By in window functions
I'm trying to create a dynamic Beast Mode that uses a window function to select the first value of a column (based on date) that is part of a function that sums other columns. In excel parlance I want to be able to vlookup start_date and grab the value for the associated column, then add that to a sum of another column…
-
More Options for Workbench Scheduling
Domo needs to incorporate functionality that allows Workbench users to select a date (any day of the month) when setting up job schedules on a monthly cadence. Today there are only 3 options in Workbench 5, the 1st, the 1st and 15th, and the last day of the month. This is unacceptable as we have many use cases where we…
-
Allow Users To Show Time in Local Time
We have users around the world and we store our dates in UTC. But users would really like to view the UTC Date Time in there local preferred time zone. Currently we have to add a lot of beast modes and formulas inside of datasets to accomplish this. And we end up storing the data many times. And create cards to show the…