date
Discussion List
-
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…
-
Pendo connection: how to add a date column to a dataset?Hello! I have created a Pendo connection to domo but a date column was not pulled over with the dat…
-
Social Media: Follower Total for yesterdayHi guys, I am trying to create a formula that Account Engagement Rate. As a part of the calculation…
-
Limit Date Selector Card for User InteractionI have a dataset that has multiple report dates with each value summing up total for that day (each…
-
Beast Mode Date issueI'm trying to build a beast mode field that does the following... When the date_created is great th…
-
Generate Date Range Column from Two Date ColumnsHi all ! Im trying to generate a date column with a range of dates from two columns: Table I have …
-
Scheduled reports are aggregated even if the card shows data on a daily basis?Good afternoon, Is there a way to have scheduled reports to display data on a daily level? Cards th…
-
Dynamic date range (last two quarters)HI All, I am looking to create a dynamic date filter on my card. The objective is to get last two f…
-
Dynamic Target Based on Current DateHello all, I am currently utilizing a gauge card with a target metric. What I would like to do is h…
-
Forecast monthly expenseI'm trying to create a formula within ETL that will help budget owners understand how their expense…
-
Is there a one-letter abbreviation for month?I am aware that I can use %b for the abbreviated month (three letters) and %M for the full month, b…
-
Adding business days to a date via MagicETLHi, I'm currently calculating a deadline using a dynamic formula in MagicETL. It looks like this: C…
-
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…
-
How do I filter on two dates?Long time lurker, first time poster here. I need to create a metric within either the ETL stage or …
-
1「タイムゾーンの問題に関するよくある質問」を検証してみたタイムゾーン関連の話題はKnowledge BaseやMatzさんが日本語Dojo内で丁寧な解説があります。ですが私自身…
-
Issue with dates in ETLHello everyone! So we use filters similar to this in Domo and noticed that for some reason all resu…
-
Is this doable? Seeing percent of total day sales by hour using Timestamp column.Hello! I have a problem that needs to be visualized and it was phrased to me like this: I need to s…
-
Group Sales Data by Hour by DayHi! I have a dataset that has a timestamp as the date column. I need to sum the sales by hour for e…
-
use fields from different tables group by date to calculate percentageHi, I am trying to calculate a percentage using two fields from two different tables in SQL Magic T…
-
Custom Month Filter for building cardsHello! I am currently building simple gauge cards that show sales for today, week, and month vs our…
-
Weird/Random Question about the date filter.I have a card that is a POP trendline and is comparing current year to the previous 2 years aggrega…
-
Is there an easy way to calculate the days left in the month to insert in a Beast Mode equation?I'm working on a Beast Mode where I have a given an amount of production that I want to divide by t…
-
Beastmode for Week starting MondayI have a colleague whose reporting week starts on Monday but our Domo instance starts our weeks on …