Magic ETL
Ask Magic ETL questions and get answers from Domo peers
Discussion List
-
How can I create a custom moving date rangeI need to create a custom date range that moves with the current day. It needs to show the date ran…
-
Adding year value to MM/DD date field.I have a free text note field that we preface each note with a MM/DD format date. I am trying to ad…
-
How to count unique value in a columnIf I have a following list of data - 1,1,2,2,2,3,3,3,3,4,5,5,6,6,6 and I want to know how many uniq…
-
Regular expression/RegEx cheat sheet and ETLs you can use RegEx in?Hey all, I am extremely new to DOMO so I'm still adjusting to using this. I sometimes use the R…
-
Mysql Flow - DATE_FORMAT not working.I am attempting to format a java long date string in DOMO using: DATE_FORMAT(`createdDate`,'%m %d …
-
append rowsHello all, I have a question on an append rows which isn't working, I have a field, equipment_i…
-
Case to a Negative NumberI have a beast mode to calculate the distinct count of products from transactions. These transacti…
-
Calculating weeks on hand based on forecast of subsequent weeksHi, I have the following dataset: Item Date Projected Inventory(PE) Forecast(FC) A Jan…
-
Syntax Error when using beast mode to create Case Statement for data flowI received syntax error message `Invalid Formula : A column in this calculation did not exist` when…
-
"Count not run DataFlow" - Why??I am trying to run a DataFlow using data from an imported CSV. It says it's running then I get an …
-
How can I calculate the percentage that a beast mode result is of a column set to 'count'?Hi, this might be simple for some of you but i'm really struggling! Below is a table I have creat…
-
How to replace an existing datasetI'm trying to create a dataflow that increments a counter. Dataset ds1 has one record with one fiel…
-
case when something then blankHow would I write a case if I have a field 'link agency id' to the following, if the the link agenc…
-
Calculating the sum of one column divided by the sum of another column - keep getting wrong answerHi, I am trying to get a calculation that measures how many hours it takes to generate a lead. In …
-
Error when trying to Declare a CursorI am getting a syntax error with the below code but can't figure out why. Anyone know why when try…
-
Next Up Summary #I want to write a summary number that notes the "Next Up" City in my data. X axis are…
-
Quickbooks Enterprise - ETL Transaction Pickup IssueThe nuts and bolt of the issue is our Quickbooks ETL logic is not picking up edits made by end user…
-
Trying to filter out rows, where a certain column has NULL valuesHi, I have a dataset of almost 2 billion rows. I need to filter out rows, where a certain column h…
-
Beast mode where the rank of the rows in a Dashboard can be introduced.Is there a way to create a column in a Dashboard with sequential row numbers.? I am trying to repo…
-
Self Join Outer JOIN not working as expectedHi, I am trying to do Outer Join on the same table. However I am not getting the result that is…
-
How to transform from Excel Sumif formula to Domo ?Hi, I have a data report with a template that looks like this in Excel: And I need to transform…
-
Summing column values based on datesI'm trying to sum values as they fall within a range of dates. I think I have to do this in Beast M…
-
Case Statement with AND function in SQLI am using below query to mark the two fileds as 'Exclude' SELECT *, CASE WHEN `account_number`…
-
combining multiple rows into oneI have a table called continuity with for a specific order can have a driver, tractor, and trailer …
-
Filter to Last 12 Months (dynamic)I've got two data sets I am trying to combine in Magic ETL to calculate inventory turns. In the sa…
-
Date minus a few weeksHello guys, Am looking for code which states: Return X (actuals) between (current date minus …
-
can i use the between operator in a case statement in a beastmodeI'm trying to write a CASE() statement in BeastMode that is similare to using the BETWEEN operator …
-
How do I delete records in an ETL data flow?Good Day, I have an ETL data flow that is recursive in nature updating Google Analytics data on…
-
Help for nested case statement in beast modeI have these two measures made in beast mode that looks like this: Status CASE WHEN `Delivery` =…
-
how to use the percentage of a category as the summary numberHello, I have this card that looks like this (Showing only one month's data) What I want to sho…
Categories
- 10.5K All Categories
- 3 Connect
- 913 Connectors
- 250 Workbench
- 458 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 183 Visualize
- 249 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 245 Distribute
- 62 Domo Everywhere
- 242 Scheduled Reports
- 20 Manage
- 41 Governance & Security
- 168 Product Ideas
- 1.2K Ideas Exchange
- 10 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive
Popular Tags
- Connectors 417
- Cards 408
- Magic ETL 384
- Beast Mode 365
- Dataset 332
- Filters 183
- Card Builder 176
- API 172
- Dashboard 163
- Data Flows 159
- Workbench 147
- SQL 131
- Charting 130
- Date 126
- Analyzer 121
- Table 120
- Governance 102
- Domo Everywhere 98
- Visualization 96
- Admin 95
- Embed 72
- Pages 68
- Export 61
- Error 58
- PDP 55