-
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…
-
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…
-
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…