Dataflows
For all your Beast Mode, Magic ETL & Dataflow Questions.
Discussion List
-
Creating a join from a lookup tableI have created a dataflow that joins two sets of data together, however when i join them together i…
-
-
Help with Magic ETL to find the status of SKU items manufacturedI have a delay table (as below) where a SKU is identified by the combination of mmodel and srno and…
-
Historic Timesheet AnalysisI'm working on an analysis of our historic timesheet data and trying to calculate our employee util…
-
Case using Between with TextHello, I am trying to use the statement: CASE WHEN `START_ZONE` BETWEEN 'A' AND 'Z' THEN `PICKUP_TE…
-
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…
-
Help with Magic ETL to calculate the distinct count of pickup numbers by plantHi All, I am trying to get the distinct count of pickup numbers by plant and pickupmonth year..Plea…
-
Forecast monthly expenseI'm trying to create a formula within ETL that will help budget owners understand how their expense…
-
Moving one column under anotherI have a table with 5 columns: column 1 is an ID, columns 2 and 4 are codes, and 3 and 5 are corres…
-
Sorting Year date Filter in Ascending orderHi All, I have a beast mode created as CONCAT(YEAR(`pickupDATE`),'-',MONTHNAME(`pickupDATE`)) which…
-
Magic ETL - Group By Tile - Sum Multiple Integer ColumnsHi all, I have a Magic ETL flow going currently where I have three input datasets that I am appendi…
-
Is it possible to calculate 6 months of data for a metric?I am trying to collect Customer data Month over Month data for a metric that uses data from the pas…
-
Is there a way to share multiple datasets with someone at once?In stead of doing it one by one?
-
CRM Sales Formula HelpHi, I need help in creating a formula to write referral data to a new column. In the Dataset we hav…
-
LISTAGG or equivalent during data import from NetSuiteWhat SQL should I be using during an import to collapse data from a column into ',' delimited strin…
-
How can I get the data from several feeder cards to populate a master card?Hello. I have built a page in DOMO that has several cards. Most of the cards are filter cards, bu…
-
How do I parse column data into separate row for each unique sets of values?I have a Jira Dataset using the Jira Connector. The Sprint column contains a string of data like be…
-
How do I return a string column value from the MAX() of another column value?Let's say I have the following: I want to group by the invoice # by dropping the SKU, returning the…
-
Dividing two integer columns that contain 0 values causing incorrect percentage value display (CTR)Hi all, I've run into an "issue" where I can't seem to get Average/AVG values to calculat…
-
Calculating the count of entries not present in the future date in comparison to the previous dateHi All, Hope you are doing well!...I am trying to build a magic etl for getting the number of entri…
-
Convert null numeric values to '0' in Magic ETLTrying to convert null values in an numeric column in an Excel spreadsheet in order to perform calc…
-
Filling in blanks, based on next valueI have a dataset in which a User ID will be identified during a session.... and then later change U…
-
ETL or beast mode for Dynamic assignment of month based on current dateHi All, Hope you are doing well..I am trying to convert a plan table as below into the table below …
-
Looking up values from secondary data source but for multiple columns in primary data sourceSo I'm having some trouble wrapping my head around a solution for this scenario in Magic ETL: -I ha…
-
How can i write this sql statement in domo?where a.Customer NOT IN(select distinct Customer from CustomerSalesData where InvoiceDate < '202…
-
Variable Dates (User Defined) and Status DeterminationHello there. Hoping to find a solution to an issue I am trying to solve. Summary I have a series of…
-
ZIP code leading zeros being removed in datasetI have a dataset and one of the columns is ZIP codes. The leading zeros are being removed when uplo…
-
Is it possible to use a Domo card as an input for an ETLHi, I would like to create an ETL using a Domo Card as an input dataset. Is there any way to do it?…
-
Null valueVery basic question here, trying to create a calculated column returning "TRUE" if anothe…
-
Checking the existence of an entry in the immediate future date and counting in future dateHi All, Hope you are doing well!...I am trying to build a magic etl for getting the number of entri…
Categories
- 11K All Categories
- 5 Private Company Board
- 2 APAC User Group
- 12 Welcome
- 43 Domo News
- 10K Using Domo
- 2K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 349 Workbench
- 267 Domo Best Practices
- 12 Domo Certification
- 474 Domo Developer
- 51 Domo Everywhere
- 111 Apps
- 728 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 31 お知らせ
- 65 Kowaza
- 303 仲間に相談
- 664 ひらめき共有