date
Discussion List
-
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 …
-
How to delete portion of text in a column in the ETL?I have a date column that is in this format: The format of the date is fine, but what I am trying …
-
-
Adding an "Activity_Date" to a nightly refresh dataset.I just set up a connection for a dataset that doesn't have any fixed 'date' column. The only date c…