Dataflows
For all your Beast Mode, Magic ETL & Dataflow Questions.
Discussion List
-
ETL Option to blank fieldIm trying to get a field that has blank values to get data from another field is there another way … -
Help with Beast code to do color coding on the data..Hi All, I am trying to do a color coding on two columns in my card (1 yr change % and 3 year change… -
Adding data that matches a date to a date dimension table.I have HR data that has Start Date and End Date (or null) for each employee. I am looking to be ab… -
Formula cannot be addedHello, I am a a beginner user on Domo (used before on Alteryx). I have tired to add formula the th… -
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…
Categories
- 11.1K 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
- 13 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 ひらめき共有
