Date

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…
Fixed to Flex Date selection
Hiya, does anyone out there know best practice (if possible?) to set more dynamic date ranges? Say I want to display “campaign to date” e.g. launch was on 2/4/2023 and I want my dashboard/cards to display data from that fixed point through [today] (variable) — how is this achieved? The only options I can see are either…
Using date filter as input for Beastmode calculated field
Hi, I have a Beast mode calculated field where I use MAX('Sales_Date') to keep the calculations fresh automatically (as we are getting the data with 1-2 months lag so I can't use current date). Problem is when users start changing the date range filter in the dashboard to a range not including the MAX('Sales_Date') in the…
Filtering data automatically for a specific Monday in a Domo dataset
Hi Everyone. I have a Domo dataset that updates daily but I need to create a chart that is essentially a snapshot in time showing WoW as of every Monday. I am not coming up with any way to do something easily in BeastMode that would work for me. Any help is greatly appreciated. Thanks!
Calculate time between two dates during business hours, excluding holidays & Sat/Sun
Need to calculate the elapsed time/minutes between Start Date and End Date, using business hours of 9:00AM to 5:00PM, excluding Saturday/Sunday & holidays. Anyone able to help? either in Magic ETL or Beast Mode.
How do I change my week to Mon - Sun and fix this report?
I have an auto weekly report that shows the dates of a week and the corresponding data. The report goes out on Monday and I need it to show the previous two weeks (Mon - Sun), not including the current Monday data. Right now I have manually typed the dates (if 1.2.23, 1.3.23..then week = 1/2 - 1/8) and select the next week…
Total/Subtotal options for dates
When building a table, it'd be good to have the option to subtotal date fields by something other than COUNT. Basic options like MIN or MAX, would help answering key business questions like when the last interaction took place, or when we first interacted, while still displaying in the table the full list of interactions…
Converting string to date
Hi, I know there's a STR_TO_DATE function but maybe I could use more insight because it's not working. I have a date field that looks like this: 8-1-22 I want to convert this to a date. How can I achieve this with a ETL formula tile? Thank you.
Additional Date Filters and Conditions
It would be helpful if there were additional date filters and conditions available to select. For example, we have reports for previous day shipments which works great Tuesday - Friday. However on Monday that report is blank because no shipment transactions were completed on Sunday. It would be great if there was a toggle…
Why are my days of the week out of order when there is a 4-day work week?
How do I filter duplicative entries when two date fields are involved? (entry & modified dates)
Hey Domo Smarties! [Annotated Screen Cap Below] What's the best way to filter out duplicate rows according to the latest modified date in an ETL? Desired Result: One unique entry by "start date" and "model" with the latest "ob modified date".
Calculate Previous Quarter Start and End Date
Hello! I am looking to calculate the Previous Quarter Start/End Date and the Previous Two Quarter Start/End Date. For example: Input: November 8, 2022 Desired Output: Previous Quarter Start Date - July 1, 2022 Previous Quarter End Date - September 30, 2022 Previous Two Quarter Start Date - April 1, 2022 Previous Two…
Can you subtract days based on case when statements?
Hello! I have a case when statement that I need to subtract a certain amount of days based off of: Case when 'ID' = '1066' THEN `Maturity Date` - 45 when 'ID' = '1019' THEN `Maturity Date` - 55 when 'ID' = '2600' THEN `Maturity Date` - 66 when 'ID' = '2507' THEN `Maturity Date` - 70 when 'ID' = '1075' THEN `Maturity Date`…
Using RegEx to Extract Date
Hi all! I am looking for advice on extracting a Maturity Date from a column containing a string of text, example: string: 12months,MATURITY DATE:23-Jun-2022,BALANCE;$12345,PRODUCT Return: 23-Jun-2022 I am able to successfully select the date by using: \d{2}-[A-z]{3}-\d{4} But am unable to replace this so that it only…
how to the find difference between dates ( in days ) that are in one column?
I am currently trying to figure out the days between each customers transaction. I know you can use the DATEDIFF function but what if my dates are all in one column? Any suggestions?
Convert all dates to last day of year
I am trying to convert all my dates to the last day of the year in a beast mode. I have a column in my dataset that is already showing the year for the data and have tried this STR_TO_DATE( CONCAT(`YEAR`,'-',12,'-',31),' %Y-%m-%d ') It doesn't seem to work. Any help would be appreciated
Can't Graph by Month
I've merged two tables and used the following formula to make sure the date doesn't get converted to String The two tables joined successfully. But My chart doesn't let me Graph By - Month The Table format still shows as 'String' under the Date columns. What can I do maintain the dates as 'Date' format so that I can Group…
Beastmode for Datetime to Group by Month in a Mega Table
Hi. I need to create a Logins by Month Mega Table. I have a datetime field for each login. I want to create a beastmode for the month of the login so that I can count by month. I want this column to sort correctly. I am having some trouble finding a good way to write the sortable beastmode for Login Month. Any ideas?
How do I convert a string to a date within Magic ETL?
I've seen questions asked about converting string to date, and answers were all given to use Beast Mode or add a separate field. Is there a way to do this in Magic ETL? I want to just have all the cleaning done in one place but can't find a way to do this in either version of Magic ETL.
How to properly partition in Workbench while allowing older data to come in?
I have a SQL Server dataset of 50M rows. Workbench runs the APPEND Update Method HOURLY. I use the table ID as the UPSERT key and the processing query checks the past 7 days ("Insertion Date") for new records. This updates older data unnecessarily with the same data, but protects against issues with the job not running for…
Table Date Range Field Drop Down
The table Date Range option should not be fixed on the first Date field in the table. The drop down should be functional regardless of the fields in the table. Currently, the first date field is used for the date grain. This limits functionality and flexibility in reporting. You can only select the date range field when no…
Help with Converting Time Zone - 'DateTimeOffset' to 'DateTime' in SQL Connector
Hey everyone, I'm having trouble with a conversion from DateTimeOffset to Datetime in a SQL Query (inside a SQL connector). I am trying to convert my date columns when they are imported in DOMO as UTC so they are coming in as the right time (Db is UTC, Domo is Pacific) and convert them to DateTime. When I run…
Social Media: Follower Total for yesterday
Hi guys, I am trying to create a formula that Account Engagement Rate. As a part of the calculation I need to work out what the most recent follower count is for the account. This would naturally be for the previous day as this will be the latest update. Does anyone know how to achieve this? Is it something like: Date…
Subtract Dates
I'm trying to exclude old items from my card. I'm using the following as a simple filter but it comes back as invalid. What am I doing wrong? Yes, I've confirmed they are both date fields. (CASE when DATEDIFF(`Close Date`,`POV End Date`) > 365 THEN 'Do Not Count' Else 'Count')
Period Over Period Multi-Value cards zeroing out when user changes the date
Good afternoon, I have several Multi-Value cards displaying both month-over-month and year-over-year values. They work great as is - but the values change to zero when a user changes the date at the page level. Is this supposed to happen or a side-effect of shoddy card building? Thanks!
Parsing Dates with Different Formats
Does anyone have any guidance for using a formula/function in a beast mode or using the regex functionality to ensure Domo recognizes all of the dates below as the same? 5/12/2022 5/12/22 2022-05-12 5.12.2022 5.12.22

Date

Discussion List