date
Discussion List
-
累積データを連続性のあるグラフにしたい現在上の図のように12/19に215、12/29に216とデータが入力されている状況です。 12/20~28にも215と数値を…
-
Creating an Artificial downtime for maintenance for only week and work hoursI am trying to calculate downtime within DOMO. The downtime we have currenlty coming from the other…
-
Calculate time between two dates during business hours, excluding holidays & Sat/SunNeed to calculate the elapsed time/minutes between Start Date and End Date, using business hours of…
-
Have a row displayed with 0/NULL when filtering by date when there's no dataTried my best to summarize in the question... I have a data set of Google Adwords Data. I'm putting…
-
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 …Answered kathint303 13 views 2 comments 0 points Most recent by MarkSnodgrass Data Platform & Data Science
-
Converting string to dateHi, I know there's a STR_TO_DATE function but maybe I could use more insight because it's not worki…Answered ✓ jrtomici 22 views 2 comments 0 points Most recent by jrtomici Data Platform & Data Science
-
-
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 ac…Answered ✓ RocketMichael 23 views 2 comments 0 points Most recent by RocketMichael Data Platform & Data Science
-
Calculate Previous Quarter Start and End DateHello! I am looking to calculate the Previous Quarter Start/End Date and the Previous Two Quarter …Answered AddieB 227 views 3 comments 0 points Most recent by Alfrancis_Kallos Data Platform & Data Science
-
How can I convert an Excel date code into a normal M/D/Y formatted date?Hi All, I have some data that I link to DOMO via the Google Analytics connector. It's provided by …Answered ✓ HowDoIDomo 43 views 3 comments 0 points Most recent by DashboardDude Beastmode & Analytics
-
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:…Answered ✓ ttaylorkar 24 views 1 comment 0 points Most recent by MarkSnodgrass Beastmode & Analytics
-
Using RegEx to Extract DateHi all! I am looking for advice on extracting a Maturity Date from a column containing a string of …
-
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…
-
Convert all dates to last day of yearI am trying to convert all my dates to the last day of the year in a beast mode. I have a column in…
-
Can't Graph by MonthI've merged two tables and used the following formula to make sure the date doesn't get converted t…
-
Beastmode for Datetime to Group by Month in a Mega TableHi. I need to create a Logins by Month Mega Table. I have a datetime field for each login. I want t…
-
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 …
-
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 …
-
Help with Converting Time Zone - 'DateTimeOffset' to 'DateTime' in SQL ConnectorHey everyone, I'm having trouble with a conversion from DateTimeOffset to Datetime in a SQL Query …Answered ElliotGitter 132 views 1 comment 0 points Most recent by ElliotGitter Data Platform & Data Science
-
Social Media: Follower Total for yesterdayHi guys, I am trying to create a formula that Account Engagement Rate. As a part of the calculation…
-
Subtract DatesI'm trying to exclude old items from my card. I'm using the following as a simple filter but it co…
-
Period Over Period Multi-Value cards zeroing out when user changes the dateGood afternoon, I have several Multi-Value cards displaying both month-over-month and year-over-yea…
-
Parsing Dates with Different FormatsDoes anyone have any guidance for using a formula/function in a beast mode or using the regex funct…Answered user10986 141 views 9 comments 0 points Most recent by user10986 Data Platform & Data Science
-
1ページ内の特定のカードのみページフィルター適用外ページ内で特定のカードのみページフィルタの適用がにしたいです。 やりたい事としては、データセット内の…
-
Is there a way to create a static temp table in Beast Modes?I'm the MajorDomo for a large retailer, and our Fiscal Calendar uses a 4-4-5 format. This means we …
-
Beast Mode Formula for Previous Complete WeeksI need to display results in cards from the last complete weeks in a dataset. (This dataset is on …
-
How to Deal with Multiple Date FieldsI have a perplexing issue I'm trying to solve. I have data coming from several different data sour…Answered pstrauss 113 views 4 comments 0 points Most recent by pstrauss Data Platform & Data Science
-
Filter multiple months by specific days of the monthHi - I'm looking for a way to take a card with a date range of the previous 13 months and have the …
-
Add Data that has been modified in the last 7 daysI have a snowflake dataset that has a modified date column. I want to merge the data that has been …
-
How to convert Milliseconds into DateI have a data set with timestamp represented in milliseconds and I want to convert it into date . D…